How to fix N/A error using RTD function?

Rafael Santomenna 0 Reputation points
2026-08-11T20:58:51.2633333+00:00

I have been using RTD functions for a year now, and suddenly last week I was prompted with the question to update the data or not to update the data. Both of the answers lead to all of the data that is linked to the RTD function reading out N/A. The issue temporarily resolved itself for a day, but has returned and persisted through all the possible remedies I have tried. Does anyone have any ideas?

Microsoft 365 and Office | Excel | Other | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Xavier-D 11,805 Reputation points Microsoft External Staff Moderator
    2026-08-12T02:07:07.34+00:00

    Hello Rafael Santomenna

    I can see that you are having the #N/A error when using RTD function

    The #N/A error suggests that Excel is no longer receiving data from the external program or add-in that supplies the RTD feed. This may be related to the RTD provider rather than the workbook itself.

    Could you please confirm:

    • Which application or add-in provides the RTD data?
    • Is that application open, connected, and signed in before you open the workbook?
    • Does the issue affect all RTD workbooks or only this file?
    • What troubleshooting steps have you already tried?

    This information will help us avoid repeating steps and determine whether the issue is with Excel, the workbook, or the RTD provider.

    I hope to hear update form you soon.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.