Trading Economics Excel Add-In

• The Trading Economics Excel Add-In installer can be downloaded here: Download TE Excel Add-In.

• Requirements: Microsoft Windows with Excel 2010, 2013 or 2016 and Office 365.

• Note: If Windows shows a warning just click on “More info” and then install.

• After installing the Add-In, open Excel, click the TE tab, and then click Login. To access data, enter your API key in the APIkey menu (see API Key below).

• If you do not have an API key yet, visit the API pricing page and subscribe to a plan.

• To use this Add-In, you need a Trading Economics API key.

• If you do not have a key yet, subscribe on the API pricing page.

• Paste your API key in this menu.

• After changing the API key, click Save Changes and then Login to refresh permissions.

Use this section if the add-in installs but the TE tab does not appear, does not load, or formulas behave unexpectedly. The checks are ordered from the most common cause to the least common, so follow them top to bottom.

1. Verify the installation folder

First, confirm that the Trading Economics folder exists and is complete.

The default location is:

*C:\Users\your-user\AppData\Roaming\TradingEconomics\Trading Economics Excel Add In*

This folder should contain the core add-in files:

• TE.dll
• TE.dna
• TE32
• TE64.dna
• TE64

After the add-in has been used, you may also see:

• teLogs
• teLogsArchive
• APIKey
• FormulaHistoric

If any of the core files are missing, the installation is incomplete. Reinstall the add-in and verify the folder again before reopening Excel.

2. Enable the add-in in Excel (TE tab not visible)

If the folder is fine but the TE tab does not appear in the Excel ribbon, the add-in is probably not registered. Open File > Options > Add-ins. You will need to check two lists in the Manage: dropdown at the bottom: Excel Add-ins and COM Add-ins.

a. Register the Excel Add-in

1. In Manage: choose Excel Add-ins and click Go.

2. If TEconomics Add-In is listed, make sure its checkbox is enabled.

3. If it is not listed, click Browse… and navigate to the installation folder:

   *C:\Users\your-user\AppData\Roaming\TradingEconomics\Trading Economics Excel Add In*

4. Select the file that matches your Excel version:

   • TE32 if your Office/Excel is 32-bit.
   • TE64 if your Office/Excel is 64-bit.

To check your Office bitness, go to File > Account > About Excel and look for “32-bit” or “64-bit” at the top of the dialog.

b. Enable the COM Add-in

1. Back in the Add-ins screen, in Manage: choose COM Add-ins and click Go.
2. Enable the TEconomics Add-In checkbox and click OK.
3. Confirm that Load Behavior shows Loaded.

Restart Excel after making these changes.

3. Check the Trust Center

If the add-in is registered but Excel still blocks it, the Trust Center settings are the next place to look.

a. Allow application add-ins

Go to File > Options > Trust Center > Trust Center Settings and click Add-ins in the sidebar. All three checkboxes should be unchecked. In particular, make sure Disable all Application Add-ins is not selected, or Excel will block the TE add-in from loading.

b. Add the install folder as a Trusted Location

1. Still in the Trust Center, click Trusted Locations in the sidebar.

2. Click Add new location… and browse to the installation folder:

   *C:\Users\your-user\AppData\Roaming\TradingEconomics\Trading Economics Excel Add In*

3. Check Subfolders of this location are also trusted.

4. Click OK to confirm, then restart Excel.

5. Re-enable the TE add-in as described above and restart Excel again.

4. Formulas recalculate automatically on open

If TE formulas refresh every time you open a workbook, the workbook likely has Force Full Calculation enabled. To disable it:

1. Open the affected Excel file.

2. Press ALT + F11 to open the VBA editor.

3. Press CTRL + G to open the Immediate window at the bottom of the screen.

4. Check the current status by running:

   ?ActiveWorkbook.ForceFullCalculation
   

5. If it returns True, turn it off by running:

   ActiveWorkbook.ForceFullCalculation = False
   

6. Save the workbook to keep the change.

7. Close Excel, reopen the file, and check if the issue persists.

Still not working?

If none of the steps above resolve the issue:

• Close all Excel windows and reopen Excel.
• Run the installer again as Administrator.
• Collect the log files inside the teLogs folder and share them with the Trading Economics support team.