Troubleshooting Installation

This page is the guide for troubleshooting installation issues with OLAP PivotTable Extensions.

Restarting Excel After Installation

The first thing to try is to restart Excel. If you install OLAP PivotTable Extensions while Excel is open, it must be restarted. Close all Excel documents and close Excel. Then open Excel again to see if that solves the problem.


Is Your PivotTable an OLAP PivotTable?

If you click on the PivotTable then press Alt-F11 then Ctrl-G then paste the following into the Immediate window and press enter:

?ActiveCell.PivotTable.PivotCache().OLAP

Does it say True?

If not, then you PivotTable is a native PivotTable that's summarizing some table or other data in the spreadsheet or SQL table. You have to have an OLAP PivotTable (that is, one connected to an Analysis Services server) for my add-in to work.


Repairing the OLAP PivotTable Extensions Installation

Starting with Release 0.7.0, the installer should fix all of the issues listed below. So if OLAP PivotTable Extensions is not working, try to repair the installation as follows, and that should fix the problem.

On Windows XP, go to Start... Settings... Control Panel... Add or Remove Programs. Click on OLAP PivotTable Extensions and click Change, on the next screen choose to Repair OLAP PivotTable Extensions, and click Finish.

On Windows 2003, go to Start... Control Panel... Add or Remove Programs. Click on OLAP PivotTable Extensions and click Change, on the next screen choose to Repair OLAP PivotTable Extensions, and click Finish.

On Windows Vista or Windows 2008, go to Start... Control Panel... Classic View... Programs and Features. Right click on OLAP PivotTable Extensions and click Change, on the next screen choose to Repair OLAP PivotTable Extensions, and click Finish.

On Windows 7, go to Start... Control Panel... Uninstall a program. Right click on OLAP PivotTable Extensions and click Change, on the next screen choose to Repair OLAP PivotTable Extensions, and click Finish.


Manual Troubleshooting

If you prefer to troubleshoot the installation manually, then use the following information and screenshots. Note, with Release 0.7.0, the following screens will say "OlapPivotTableExtensionsShim.dll" instead of "OlapPivotTableExtensions.dll.manifest".


Is It Disabled?

The first thing to check is whether OLAP PivotTable Extensions is disabled. Click on the Office button (in the top left) and choose Excel Options. Click on the add-ins tab, then scroll down and see if OLAP PivotTable Extensions is disabled:

DisabledAddIns.png

If it is disabled, then select "Disabled Items" from the Manage dropdown at the bottom and click Go. Then enable the add-in using this dialog:

DisabledItems.png

Then check whether the add-in is inactive using the following instructions.


Is It Inactive?

Then check whether OLAP PivotTable Extensions is inactive. Click on the Office button (in the top left in Excel) and choose Excel Options. Click on the add-ins tab, then scroll down and see if OLAP PivotTable extensions is in the inactive list:

InactiveAddIns.png

If it is inactive, then select "COM Add-ins" from the Manage dropdown at the bottom and click Go. Then check OLAP PivotTable Extensions and click OK.

ComAddIns.png

Then repeat the instructions above making sure it is now active, not inactive.


Is It Recognized By Excel?

If you have installed OLAP PivotTable Extensions version 0.7.0 or higher and still OLAP PivotTable Extensions doesn't appear anywhere in the list of add-ins above, then the installer may have failed. Uninstall OLAP PivotTable Extensions, then reinstall using the following method (instead of running the EXE).

Open a command window (on Vista or later, by right clicking and running the command prompt as an administrator) then CD to the appropriate directory with the MSI from the installer and run the following command:

msiexec /i "%TEMP%\OlapPivotTableExtensionsSetup\OlapPivotTableExtensionsSetup.msi" /log install.log

Post that log file under the Issue Tracker tab.

Last edited Jul 7, 2012 at 4:38 PM by furmangg, version 5