Note: The help system has been updated - click here to go to the most recent version
 

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

Home  Previous  Next

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

 

NA

 

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.

 

 Excel_options

 

 

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