After installing the PowerPivot for Excel add-in there are various things that you can to do attempt to debug the situation:
- First, and I know this sounds dumb, but I have to point it out – you have to be using Excel 2010. PowerPivot does not run under earlier version of Excel.
- Next ensure that you have the additional “Shared Features” option checked in your Office install options. We need this for VSTO support.
- Next ensure that you have the COM add-ins to see whether it’s checked, if not check and try it again. You might see something like:
- Check to see whether or not the PowerPivot for Excel add-in is disabled. If disabled, enable it and try again. Sometimes Excel won’t enable it by default, or you don’t accept the signing when the add-in first comes up after registration. Check whether the add-in is in disabled items list. You might be wondering “Why does Excel disable PowerPivot?” The answer is that if Excel believes that an add-in is interfering with the usage of Excel, it disables the add-in. This could be something as simple as a delay in some startup code, i.e. you hit a network ‘hiccup’ at just the wrong time, or something like that.
- If you still cannot get a valid error message, please try this
- Open My Computer Properties
- Click on Advanced Tab
- Click on the Environmental Variable
- Click on New User Variable
- Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
- Repair PowerPivot For Excel from add/remove program
- Open Excel again, it will prompt an error message – that might lead you to a better understanding of the problem.