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…

Picture1

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

Picture2

 

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

Picture3

4. Check the PowerPivot checkbox, click OK.

Picture4

 

Leave a Reply

Your email address will not be published. Required fields are marked *