Article ID: 277617
Article Last Modified on 1/31/2007
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Excel 2002 Standard Edition
This article was previously published under Q277617
SYMPTOMS
If you use a formula that includes the RTD function in Microsoft Excel, the formula may evaluate to #N/A.
CAUSE
This issue occurs if any of the following conditions are true:
- The RTD server returns unexpected information, either because the Topic ID is wrong or the array returned by the server contains extra, unexpected information.
- The RTD server fails.
- The RTD server is not registered on the computer.
- The RTD server returns "-1" for Topic Count.
- The RTD server returns "-1" for Heartbeat.
- The RTD function is waiting for the server to return information. If the RTD server is running over a slow connection, or the server establishes other connections before returning results to Excel, #N/A remains in the cell until Excel receives results.
RESOLUTION
To resolve this issue, use the following methods, in the order that they are presented. Go to the next method in each case only if the current method does not resolve the issue.
- Stop and then restart the server.
- Exit and then restart Excel.
- Debug the server.
MORE INFORMATION
The RTD function, or the formulas that use it, evaluate to #N/A for a variety of reasons. It may be that the RTD server has failed completely, that it has returned an invalid Topic ID, or that some other error has occurred in retrieving data from the array of values returned to Excel by the RTD server.
Because Excel is not able to distinguish between these errors, the #N/A value is displayed in the cell that contains the RTD function in every case, and the #N/A value appears in all cells receiving data from the server in question, regardless of the Topic used.
REFERENCES
For more information about the RTD function, click the following article number to view the article in the Microsoft Knowledge Base:
289150 How to set up and use the RTD function in Excel 2002
For more information about how to set up an RTD server, click the following article number to view the article in the Microsoft Knowledge Base:
285339 How to create a RealTimeData server for Excel 2002
Additional query words: XL2002 inf prb XL2007
Keywords: kbdtacode kbpending kbprb KB277617
