Forum Discussion
Powerpivot not showing in ribbon
Yes, Power Pivot shall be on Office 365 Home. Check File->Options->Add-ins->COM Add-Ins (drop-down list at the bottom)->Go and here you'll see is it in the list or not. If here and not checked, check it, all Ok:s and restart Excel.
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.
