Quick way to enable PowerPivot tab

Sometimes PowerPivot/Excel crashes or hangs, and you need to kill the Excel process. When you open Excel again, you notice that the PowerPivot tab doesn’t show up.

Here’s a quick way to re-enable the PowerPivot tab.

1. First, we add the COM Add-Ins button to Quick Access Toolbar. This is done only once. Customize Quick Access Toolbar to add COM Add-Ins…


2. From Developer Tab, choose COM Add-Ins… Add, OK.



3. If the PowerPivot tab, for any reason, becomes unavailable; click on the COM Add-Ins button.


4. Check the PowerPivot checkbox, click OK.