Primary interop assemblies (PIAs) for Microsoft Excel

To use the features of IBM® Planning Analytics 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.

Computer workstations must have the PIAs installed and registered in the global assembly cache to run Office solutions that target .NET Framework.

You can install the complete set of PIAs in the global assembly cache in two ways:

  • Modify the Microsoft Office setup.

    If you did not install .NET Framework before you installed the Office system, the PIAs are not installed with your Office installation. If you installed .NET Framework after you installed the Office system, you can install the PIAs by modifying the Office setup.

  • Install them from the redistributable PIA package.

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