Forum Discussion
Powerpivot not showing in ribbon
SergeiBaklan thanks for that.
I have tried the steps you have suggested. It does not appear in the COM addins, and it does not appear in the Disabled addin section either.
I have also uninstalled office and reinstalled it.
Any other ideas I can try?
I have a hunch that the article at support.microsoft.com is simply incorrect misinformation and PowerPivot is still limited to enterprise class 365 plans and standalone copies of Office Professional.
I've tried using a 365 family plan as well as a 365 Business Standard plan and neither one work. It DOES work when I buy/install a standalone copy of Office Professional (non-subscription). INSANE that I have to buy office multiple times when Microsoft's own site says it should be included.
I appreciate some time has passed but I hope this helps someone. To solve the issue of missing Power Pivot tab:
- File>Options>Ad-ins
- Highlight Microsoft Power Pivot for Excel (+ any additional options you find useful)
- Click Go...
- If Power Pivot tab is still missing from the working environment then on the excel ribbon, go to: Developer>Com Add-ins
- Check the boxes for the Add-ins you want to enable (including Microsoft Power Pivot for Excel)
- Click Ok and the tab should appear
So, I just had this problem and resolved it by doing:
Developer > COM Add-ins, and just Unselecting "Microsoft Power Pivot for Excel" and hitting [OK], then going back in there and selecting it again. Little buggy for sure but Power Pivot now shows in my Ribbon.
The issue is still present for even through dev option, here is a screenshot. I am on Excel 2016
- MidisG82 My suggestion resolved the issue for me on the latest version of office 365 - perhaps different problem for excel 2016 - sorry didn't help you!
