RefreshData Method

Microsoft Excel Visual Basic

This method is called by Microsoft Excel to get new data. Returns a Variant.

expression.RefreshData(TopicCount)

expression    Required. An expression that returns an IRtdServer object.

TopicCount   Required Long. The RTD server must change the value of the TopicCount to the number of elements in the array returned.

Remarks

The data returned to Excel is a Variant containing a two-dimensional array. The first dimension represents the list of topic IDs. The second dimension represents the values associated with the topic IDs.

ShowRefreshData method as it applies to the RTD object.

Requests an update of real-time data from the real-time data server.

expression.RefreshData()

expression    Required. An expression that returns an RTD object.

Remarks

Avoid using the RefreshData method in user-defined functions because this method will fail if it is called during recalculation.