Skip to main content
InSource Solutions

TN HistClient701 Historian Excel Add-In

  1. Last updated
  2. Save as PDF

Description

 

This article from InSource shows how to Install Historian Excel Add-in.

  • Author: Chris Cleope
  • Published: 6/18/2020
  • Applies to: 2017 Historian

Details

Registering your excel add-in

  1. Open a blank workbook in Excel.
  2. Select the file Menu, then select Options. The Excel options dialog displays.

clipboard_e7969689d55be3cfa0238772ef194d0a7.png

  1. Select Trust center, and then click Trust center settings. The trust center dialog displays.

clipboard_ed1e74c848247be69c0e7604da82494df.png

  1. Select Trusted Add-in Catalogs.
  2. In the Catalog URL field, enter the UNC path for the shared location created on the Historian Server. The UNC path should use this format: \\your server name\InsightAddin
  3. Click Add Catalog. A new line appears in the tables.

clipboard_e1e33d7216c2cb915e3d2f12345321f8e.png

  1. Click the new line and select Show in Menu Option.

clipboard_e0e8b3ac97327edc8c4db05e5febc1b4c.png

  1. Click OK. Restart Excel to apply the changes.

 

Now we need to apply the Add-in

  1. Open a workbook in Excel.
  2. Select the Insert menu, and then click My Add-ins. The office add-ins dialog displays.
  3. Select Shared Folder, then select the AVEVA Historian add-in.

clipboard_e009a8892a6f16ec1e4f6c05aacafb894.png

  1. Click OK. The AVEVA Historian add-in appears in the menu bar.

 

NOTE: This new add-in falls under the Historian SERVER group rather than Historian CLIENT.  More info on the Technology Matrix is mentioned on the Historian Server page (https://gcsresource.aveva.com/TechnologyMatrix/Report/Details/7121)