TN HistClient701 Historian Excel Add-In

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.
   
3. Select Trust center, and then click Trust center settings. The trust center dialog displays.
   
4. Select Trusted Add-in Catalogs.
5. 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
6. Click Add Catalog. A new line appears in the tables.
   
7. Click the new line and select Show in Menu Option.
   
8. 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.
   
4. 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)