Excel Add-in technical

Troubleshoot common Excel add-in problems

+ More

Table of Contents

Is it possible to disable automatic updates and specify where the add-in installs? Is it possible to disable the Upgrade box for all users? Does the tool ever send information to the Internet? If so what type of information transfers? Does the Excel Add-in store activities or history in a database? If so, where is the database located? Is there a license key? Is silent installation available for the Excel Add-in? Troubleshooting Need further help?

Is it possible to disable automatic updates and specify where the add-in installs?

In version FastmarketsAddIn.1.1.331 and above, it is possible as an administrator to enter command line arguments for the MSI installer to control the folder for the installation and a user’s ability to enable or disable updates to the latest version. There are three new parameters that provide the following capabilities:

MSIINSTALLPERUSER determines whether the Excel Add-in will be installed for the current user only (MSIINSTALLPERUSER=“1” is the default value) or for all users (MSIINSTALLPERUSER=“”).
INSTALLFOLDER specifies the directory where the Add-in will be installed. By default, it will install into the AppData folder for the current user. When not specified and MSIINTALLPERUSER=“”, the Add-In will install into “C:\Program Files (x86)\Euromoney\Fastmarkets Excel Add-in\”.
ENABLESELFUPDATE allows the disabling of Add-in updates (“true” is the default value).

Below is an example of the required syntax to specify a folder for all users with the ability to update by user disabled:

msiexec /i "FastmarketsAddin.msi" ENABLESELFUPDATE="false"
INSTALLFOLDER="C:\FolderName\" MSIINSTALLPERUSER=""

Is it possible to disable the Upgrade box for all users?

IT/System administrators can edit the following Registry Settings to disable their users' ability to update the Fastmarkets Excel Add-in providing further control around release management:

In the Registry Editor go to HKEY_CURRENT_USER\SOFTWARE\Euromoney\Fastmarkets Excel Add-in
Right click to create a new key - New > Key > DWORD (32 bit) Value and name it DisableUpdates
Set the Value data parameter to 1 to disable update buttons for users (to revert these changes amend to 0 to enable them)

After the creation of this registry key the user will no longer see the update buttons.

Please refer to the Release Notes for v1.3.904 for further information.

Does the tool ever send information to the Internet? If so what type of information transfers?

Yes, it sends credential for login and parameter of request to our systems. Everything is sent over SSL connection and is encrypted from end to end.

Does the Excel Add-in store activities or history in a database? If so, where is the database located?

No, activities and history are not stored in a database. However, there are some temporary data and logs stored at the user machine in the Add-in installation folder and user data folder.

In Fastmarkets Excel Add-In v1.1.476 and above, log and temporary files will have a location change:

From AppData\Local location under AddIn folder:
"c:\Users\<user_name>\AppData\Local\Programs\Euromoney\Fastmarkets Excel Add-in".

To Log files: c:\Users\<user_name>\AppData\Roaming\Euromoney\Fastmarkets Excel Add-in\logs\ token.dat and updateCheck.dat: c:\Users\<user_name>\AppData\Roaming\Euromoney\Fastmarkets\Excel Add-in\

Is there a license key?

No, there is no license key. Log-in to the Excel Add-in is done by users individually after installation.

Is silent installation available for the Excel Add-in?

Yes, silent installs can be used for automatic Excel Add-in installations or upgrades using the installer from either command prompt/Windows PowerShell. The syntax would be “FastmarketsAddIn.(insert version numbers).msi /quiet”.

Troubleshooting

Need further help?

Further help

If you have more questions or need further support please look at all the help content available on our Support Hub. If you can't find what you need and want to contact our support teams then Let’s get you some help.

Issue	Action to be taken
When I try to download Fastmarkets’ Excel Add-in installer in Internet Explorer, I see an error message that reads, “Your System Administrator blocked FastmarketsAddin.msi”.	Ask your system administrator to add https://downloads.fastmarkets.com/excel to the trusted sites list. Alternatively, download the Excel Add-in installer using a browser such as Chrome or Edge.
When I try to install Fastmarkets’ Excel Addin in Chrome or Edge, I see an error message that reads “Windows has protected your PC; Windows Defender SmartScreen prevented an unrecognized app from starting”.	Click on “More Info” and select “Run anyway.” Alternatively, ask your system administrator to add https://downloads.fastmarkets.com/excel to the trusted sites list and try downloading the installer again.
I’ve installed the Add-in but am unable to see the menus and toolbars in Excel.	Excel has a feature to disable third-party software Add-ins. To enable the Fastmarkets Excel Add-in, go to Excel > File > Options. Select “Add-ins” from the menu on the left. Select “Disable items” in the Manage dropdown menu, then click Go. Select “Fastmarkets Excel Add-in” and click Enable. Ensure you save and close any spreadsheets, then restart Excel. Repair functionality for the Excel Add-In installer is available either from the installer itself or from Control Panel > Programs > Programs and Features. Right-click over “Fastmarkets Excel Add-in” in the program list and select Repair.