Why do my RTD links turn #N/A in Excel?

Modified on Tue, 31 Aug 2021 at 11:38 AM

#N/A means “Not Available” and this could be caused by different reasons.

This is a common Excel error that is not related to the Infront Professional Terminal, but a known problem that can occur in Microsoft Excel. We highly recommend you to run the Infront Professional Terminal before you open any Excel spreadsheets containing RTD links. This is necessary for the RTD links to work.

#N/A might appear if some files are not placed correctly according to the installation. Therefore, repairing Excel from the Control Panel could solve the issue. This can be done by following the instructions below:

  • Click the Start button and open the "Control Panel."
  • Click the "Uninstall a program" link under Programs.
  • Scroll down and highlight "Microsoft Office."
  • Click the "Change" button and wait for a new window to open.
  • Click to select the "Repair" option and click "Continue" to authorize your computer to repair Microsoft Excel to its default settings.

The issue can also be related to the add-in options in Excel. You can also try the following:

Step 1: Go to file → Options → Add-ins.

Make sure that “ontrade.quotes” is shown as *active*. Make sure that the add-in is not placed under Disabled items. If it is disabled, try to activate it again.

Step 2: Make sure that you are running the latest version of Windows and that all updates are installed.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article