Skip to main content
InSource Solutions

TN - 1207 Troubleshooting Excel Insight Add-in

Description

 

This article from InSource discusses some common issues you may encounter when trying to access the new Insight Add-in from Excel.  This is not to be confused with the Historian Client Workbook Add-in. The Workbook Add-in is a separate add in which requires a 32 bit version of Microsoft Office.

 

Things to note:

The Insight Add-in requires a 64 bit version of Microsoft Office. 

The Insight Add-in requires Excel API version 1.2 or higher.  Which translates to either Microsoft Office 2019 or 2016 (build 1601 and later).

Before using the Add-in it will need to be registered in Excel.

Once registered the  Add-in will need to be added to a workbook.

 

  • Author: Mario Meza
  • Published: 12/20/2021
  • Applies to: Historian 2017 Update 3 and above

Details

Once added to a workbook successfully you will see a new addition to the top right of the ribbon in Excel.

clipboard_e163723f501b59ab60d28b8b47b6bfaa5.png

 

Issue 1:

Attempts to access the Add-in result in the panel on the right displaying a continues Loading notification. Resulting in the login dialog not loading/displaying.

clipboard_ed6efc8b8ff31f08e5b9c213c4d248544.png

 

Suggestion 1:

If the application is in full screen the authentication dialog box may not gain focus, as a result it may be hidden behind the Workbook, exit full screen to access the dialog.

clipboard_e0a3d16bc66c29953bc807e702f6ad391.png

 

 

Issue 2: 

You've logged in via the pop up however the pane on the right is stuck loading.

clipboard_ef1db6d618fcdfed98ae7dd333b94dd4d.png

 

Suggestion 2: 

If you are on a Server OS this can be a combination of ISSUE 1 and Internet Explorers Enhanced Security Configuration (IEESC).  You can either

 Add the blocked sites to the Trusted Sites Zone

Alternatively you can disable IEESC as outlined in this article from Microsoft.

clipboard_e64a7d6cec7e837276c608dbee19e70db.png

In this instance the sites were added to the Trusted Sites Zone which allowed the Add-in to fully load.

clipboard_e70b3d304a5d1e2cfd5e0edea070edc7f.png

 

 

Issue 3: 

A 64 bit version of office is installed but when Excel is opened you get  a Compile Error In Hidden Module dialog: 

 

clipboard_edf80c8a8d3ceea500c0a0d8d4f0a19da.png

clipboard_e4101f2a3310a62bc2560537704e70e0d.png 

 

Suggestion 3:

This is likely because the Historian Client 32 bit Add-in is currently installed which cannot work with a 64 bit version of office.

To resolve Run the AVEVA installer as Administrator.

clipboard_e4cb30cc010a765e6838b27b3b848bef3.png

Select the Modify option.

clipboard_eee04a196425e6498ffffeebcaa2e4bff.png

 

Uncheck the Historian Client Microsoft Office (32 Bit) Add-ins.

  clipboard_eda01bc2a985be4effc68a64ef1e04dce.png

 

Agree to the License Terms and Modify the Install.

clipboard_e5448c0fa617cc2511ca29ba5c8daef3b.png

 

The installer may appear to Hang at some point.

clipboard_ee473daabe1408b60fe80684a3ed0a192.png

 

Again this can be a result of the dialog boxes not gaining focus. Move the install window to dismiss any hidden notifications. 

 

clipboard_ee47b5017a8b9bf5248d9198d1beec5ed.png

 

clipboard_e1455641fcaafd1a2a4a23b8dfa5cbd7f.png

 

clipboard_e78107d2966b6ba082608b17bf240046a.png

 

Once the notifications are cleared the installation completes and you should no longer get those messages when launching Excel. 

 

clipboard_e1ee67397e0065416aab3696dfab17c23.png