At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server 2008 R2) installed on a number of developer machines. All of the machines were 64-bit running Windows 7. We had Office 2010 32 bit installed in all cases. The frustration occurred around the error message.
We verified we had downloaded the correct version and according to the following Microsoft Support article, http://support.microsoft.com/kb/982765, we also confirmed all of our prerequisites were in place. After going through this verification process, we had one of the developers completely reinstall MS Office and then install the add-in. However, we were still unsuccessful. So, we did what all good developers do and got our local desktop support guy, Steve Schuler, involved. He was able to successfully work through the issue.
Here are the steps that Steve discovered which allowed us to successfully get the PowerPivot add-in installed.
- Save PowerPivot_for_Excel_x86.msi to a local folder.
- Right click on Command Prompt and choose Run as Administrator.
- Type msiexec/i c:\data\PowerPivot_for_Excel_x86.msi into the Command window.
- Launch Excel and choose Accept when prompted to install PowerPivot.
If PowerPivot does not show in the ribbon, go to File-Options-Add-Ins and select Com Add-In’s from Manage drop-down list and choose Go. Confirm that PowerPivot for Excel is selected. If it is not selected, select it and then choose OK.
The root cause of the issue appears to be related to the security policies and administrative privileges on the machines. In our case, we are all local admins and should not have encountered the issue. We had inconsistent experiences on many machines that were tested. In some cases there was no issue and then in other cases we could only install with the steps above.
Thanks again to Steve for a job well done.