Install the Historian Excel Add-in at a Command Prompt

Before you begin

  1. 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
  2. Install Excel Add-in using the installer on your machine:
    1. Open the Command Prompt as an Administrator. (From the Start menu, right-click the Command Prompt app, and select Run as Administrator.)
    2. On the Historian install media, navigate to the Excel folder.
    3. Run the following command line: setup.exe -r.
    4. When the install runs, select the Excel option and leave the other options greyed out as they cannot be removed.

      When you run this install, a template file named setup.iss is created at C:\Windows. This file stores the installation options that you have provided during the installation.

      After completing the installation, you can then use this .iss file to install Excel Add-in at a command prompt on other machines.

      On the other Client machine where you want to install the Excel Add-in, place a copy of the setup.iss on the local directory and open a Command Prompt (Run as Administrator). Run the silent install with following command:
      setup.exe /s
      If your iss file is not called setup.iss or is in different directory than setup.exe you need to add the flag: /f1. For example: 
      setup.exe /s /sms /f1"C:\Temp\setup.iss
      Wait for few minutes (probably 3-5 minutes) for the install to complete.

About this task

You can install Excel Add-In separately or during Client Tools installation. However, do not install Excel Add-In on the machine on which you have installed Historian Administrator or data archiver.

Procedure

  1. Copy the setup.iss file to each machine on which you want to install Excel Add-in at a command prompt.
  2. In the folder that contains the setup.iss file, run the following command: setup.exe /s /sms
    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.