Troubleshooting

Owned by Brendan Hebert (Unlicensed)
Last updated: Apr 26, 2023
5 min read

Microsoft Store vs. Downloaded Version

Barchart for Excel will only work on the downloaded version of Excel. Below are the steps to verify which version of Excel you are currently running.

Step 1: Open Task Manager and expand the application that you want to examine:

Step 2: Right-click on the app, then select ‘Go to details’: 

Step 3: On the Details tab of Task Manager, take a look at the Command Line column to see where the app is running from. If you do not have the Command Line column shown, right-click on the column headers and go to the Select Columns dialog to show it:

If the command line points to c:\Program Files\WindowsApps, then it’s a Microsoft Store app.

 

Check System Requirements

Barchart for Excel requires the following to operate:

-Windows 10

-Microsoft .NET Framework 4.7.2 or later

-VSTO

-Microsoft Excel 2013 or later

 

Barchart for Excel Add-in Disabled

Step 1: Open Excel Options:

Step 2: Select Add-ins then click in the Manage drop down and select Disabled Items and then Go.

If Barchart for Excel is visible in the Disabled list, enable add-in.

 

Barchart for Excel Not Displaying in Ribbon

Step 1: Open Excel Options:

Step 2: Select Add-ins then click in the Manage drop down and select COM Add-ins and then Go.

Step 3: Make sure Barchart for Excel is checked.

If Barchart for Excel is checked but not displaying in the ribbon, Excel may have had instances running during the install. Uninstall Barchart for Excel, close down all instances of Excel and reinstall the Add-in.

 

Unregistered UDF Formulas

If Barchart for Excel cells are not populating data and displaying like below:

Step 1: Open Registry Editor:

Step 2: Go to:

HKEY_CURRENT_USER\Software\Microsoft\Office\<VERSION>\Excel\Options

Check to see if a key (OPEN or OPEN1 or OPEN2 or OPEN3…) with a value like below is present.

‘ /A "barchart.udfs" ‘ for Barchart for Excel

Step3: If not present, close out of all Excel instances (check Task Manager as well for any Excel instances).

Step 4: In the Registry Editor add the next free open key (OPEN or OPEN1 or OPEN2 or OPEN3) and the Barchart Excel value (/A "barchart.udfs) to Below:

HKEY_CURRENT_USER\Software\Microsoft\Office\<VERSION>\Excel\Options

Step 5: Close out of the Registry Editor and check Barchart for Excel again.

 

ClickOnce Trust Prompt Error

If you encounter the following error message when downloading Barchart for Excel, you will need to update your trust prompt configuration.

The below link allows you to change your configuration without having to manually update the registry.

https://www.smartlux.com/software/trust-prompt-tool/

Once downloaded, you can change the behavior setup to below and then redownload Barchart for Excel.

Internet=AuthenticodeRequired
UntrustedSites=Disabled
MyComputer=Enabled
LocalInternet=Enabled
TrustedSites=Enabled

 

Barchart for Excel Update Errors

New versions of Barchart for Excel are periodically released to production and are automatically pushed to Excel via Microsoft’s ClickOnce technology. If you encounter issues with a Barchart for Excel update you will want to check your Windows Security and the Protection history.

The Protection history will display recent potential threats that were blocked. If Barchart for Excel’s files are present you will want allow Barchart for Excel’s files to auto update in the security settings. One way this can be accomplished is by adding the Barchart for Excel’s folder to the Exclusion list in Windows Security:

 

Diagnostics and Logging

If any or all of the troubleshooting above is unsuccessful:

Step 1: Click on the Help drop down located in the Support section of the Barchart for Excel ribbon and select Diagnostics:

Step 2: Check to see if all servers statuses are green (healthy connection):

Yellow will display when you are not logged in. The server status will be red if there is no internet connection or a connection can not be established to our servers. For the latter, you will want to check with the local system administrator.

To submit your Barchart for Excel logs:

Step 1: Click on the Help drop down located in the Support section of the Barchart for Excel ribbon and select Logging:

Step 2: Choose “Detailed” Log type:

Step 3: Reproduce the error encountered after selecting Detailed logging.

Step 4: Once reproduced, export the Detailed Log files and send to our support team at support@barchart.com

Step 5: Once sent, change the Log Type back to Standard.

 

Uninstall Issues

If issues are encountered when attempting to uninstall the add-in, use the steps below to manually remove the application.

1.Open up the Registry Editor

2.Copy the following and paste “HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Uninstall” into the Registry Editor.

3.Scroll through the entries and find the Barchart for Excel add-in (note the Display Name below)

4.Right click on the UninstallString and select Modify. Copy and paste the value into a document.

Example →

"C:\Users\b-hebert\AppData\Local\Apps\2.0\27H1QT8B.YN1\7DAPM7RT.YXL\barc..vsto_88518f22667eafe3_0001.0000_cef71ad37f62a3e3\Barchart.Excel.Uninstall.exe" remove "C:\Program Files\Common Files\Microsoft Shared\VSTO\10.0\VSTOInstaller.exe /Uninstall https://install.barchart.com/barchart-excel-stage/Barchart.Excel.vsto"

5.Remove all text except for the following →

"C:\Program Files\Common Files\Microsoft Shared\VSTO\10.0\VSTOInstaller.exe" /Uninstall https://install.barchart.com/barchart-excel-stage/Barchart.Excel.vsto

6.Open the Command Prompt and enter in the value above. You will then be prompted to remove the add-in.