Installing PIAs for Microsoft Excel

To use the features of IBM® Cognos® Analysis for Microsoft Excel, you must have installed the primary interop assemblies (PIAs) for Excel. Typically, the PIAs are installed automatically when you install Microsoft Office on the computer. However, in some cases you might need to install the PIAs separately. If you did not install .NET Framework before you installed the Office system, the PIAs are not installed with your Office installation. You can install them from the redistributable PIA package.

Computer workstations must have the PIAs installed and registered in the global assembly cache to run Office solutions that target the .NET Framework 4.0 or later. However, the Office PIAs are not required on computers to run Office solutions that target the .NET Framework 4.

The Microsoft Office PIAs are installed in the global assembly cache in drive:/WINDOWS/assembly or drive:/WINNT/assembly.

Before you begin

You must be an administrator on the computer to install the .NET Framework and the Microsoft Office PIAs.

Procedure

  1. Ensure that the .NET Framework 4.0 is installed.
  2. Go to the Microsoft download website.
  3. Follow the instructions in the download page to install the primary interop assemblies.