Installation

Install the Historian Excel Add-in Using the Installer

Before you begin

Install one of the following 32-bit or 64-bit Microsoft® Excel® applications:
  • Microsoft® Excel® 2019
  • Microsoft® Excel® 2016
  • Microsoft® Excel® 2013
  • Microsoft® Excel® 2010

About this task

You can install Excel Add-In separately or during Client Tools installation. This topic describes how to install Excel Add-In separately using the installer. You can also install it at a command prompt. However, do not install Excel Add-In on the machine on which you have installed Historian Administrator or data archiver.

Procedure

  1. Run the InstallLauncher.exe file.
  2. Select Historian Excel Add-in.
    The installer runs through the installation steps.
    Note: If using certain versions of Windows (like Windows 10 or Windows 2019), you may receive an error message, stating that some of the DLL files are not registered. You can ignore these messages.
  3. When prompted to reboot your system, select Yes.

Results

Excel Add-In is installed.

What to do next

Activate Excel Add-In.

Activate Excel Add-In

Before you begin

Install Excel Add-In.

Procedure

  1. Open a new Microsoft Excel worksheet.
  2. Select File > Options.
    The Excel Options window appears.
  3. Select Add-Ins.
  4. In the Manage box, select Excel Add-ins, and then select Go.
    The Add-Ins window appears.

  5. Select the Proficy Historian Add-In and Proficy_Historian_Helper check boxes, and then select OK.
    If the Proficy Historian Add-In and Proficy_Historian_Helper check boxes do not appear, select Browse to locate the Historian.xla file for the check boxes to appear. This file is created if you have installed Microsoft Excel after installing Excel Add-In. By default, the Historian.xla file is located in the C:\Program Files\Proficy\Historian or C:\Program Files (x86)\Proficy\Historian folder.
    Excel Add-In is now ready to use and the Proficy Historian menu is now available in the Microsoft Excel toolbar.