Where did my PowerPivot Excel 2010 tab go?
Posted by denglishbi on June 21, 2010
The other day I launched Excel 2010 to do a quick calculation and changed my mind. By changing my mind I didn’t mean that I didn’t want to perform the calculation anymore, just decided I didn’t want to wait for Excel 2010 to load. The reason that it takes a while now to load is the additional add-ins that I have installed which includes PowerPivot. As long as theses are activated they need to be loaded each time. Needless to say I am somewhat impatient and decided I would simply use another application to perform the calculation so I cancelled Excel during the load process.
It is an option, not sure if it is the right one that you want to pick, but needless to say this is what I went with and this caused some other message boxes to be displayed. And at this point I simply pick the option to close or cancel because once again I am a bit rather impatient sometimes.
So once that was done I open up my handy calculator and do the original calculation that I wanted. Later on I go ahead and open up Excel 2010 because I want to actually do some PowerPivot work. Well…where did my PowerPivot tab go?
What did I do? Oh no, I lost my PowerPivot. Did I corrupt it? Do I need to re-install the add-in for Excel? Help! I decided to do a quick Bing search on the issue and I come across a posting by the one and only Dave Wickert, PowerPivotGeek, PowerPivot for Excel add-in is not coming up in Excel. This tells me that maybe I need to activate the COM Add-in. Well the only thing it doesn’t tell me is where to do that…minor detail. First I need to find where the add-ins are even displayed.
- Click File—>Options and then select the Add-Ins page
- The in the Add-Ins page from the Manage drop down list select COM Add-ins and click the Go… button
3. Now check the box next to PowerPivot for Excel and click the OK button
Now the PowerPivot tab is back in the Excel 2010 Ribbon and you are back in business.
I still don’t like having to wait for the PowerPivot add-in to load each time because I am not actually using PowerPivot every single time when I open Excel and as I have stated, I can tend to be a tad on the impatient side sometimes. It would be nice to simply have a button that I could toggle to have this feature loaded on an as needed basis. Now I will tend to shy away from using Excel just because of the load time. I will look to leverage other applications like the calculator and the Internet more to handle the basic calculations that I used to use Excel 2007 for.
Here are a couple of additional resources for troubleshooting PowerPivot issues (in addition to the one I mentioned above):