Home

Powerpivot not showing in ribbon

%3CLINGO-SUB%20id%3D%22lingo-sub-840844%22%20slang%3D%22en-US%22%3EPowerpivot%20not%20showing%20in%20ribbon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-840844%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBeen%20going%20round%20in%20circles%20trying%20to%20work%20out%20why%20powerpivot%20isn't%20showing%20within%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFound%20this%20link%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FWhere-is-Power-Pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FWhere-is-Power-Pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b%3C%2FA%3E%26nbsp%3B-%20which%20seems%20to%20indicate%20that%20it%20should%20be%20available%20for%20any%20365%20version%20that%20has%20desktop%20as%20part%20of%20it%20(mine%20does%20-%20Office%20365%20Home).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20was%20a%20lot%20of%20posts%20around%20the%20place%20prior%20to%20this%20year%20where%20it%20looked%20like%20powerpivot%20was%20NOT%20a%20part%20of%20Office%20365%20Home%20-%20but%20the%20link%20I%20put%20in%20indicates%20from%208th%20January%202019%20it%20should%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20able%20to%20tell%20me%20if%20my%20Office%20365%20Home%20should%20have%20PowerPivot%20or%20not%3F%26nbsp%3B%20I'm%20trying%20to%20update%20some%20work%20files%2C%20but%20I%20can't%20because%20of%20th%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-840844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842415%22%20slang%3D%22en-US%22%3ERe%3A%20Powerpivot%20not%20showing%20in%20ribbon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F404666%22%20target%3D%22_blank%22%3E%40Aaron_Griffiths%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20Power%20Pivot%20shall%20be%20on%20Office%20365%20Home.%20Check%20File-%26gt%3BOptions-%26gt%3BAdd-ins-%26gt%3BCOM%20Add-Ins%20(drop-down%20list%20at%20the%20bottom)-%26gt%3BGo%20and%20here%20you'll%20see%20is%20it%20in%20the%20list%20or%20not.%20If%20here%20and%20not%20checked%2C%20check%20it%2C%20all%20Ok%3As%20and%20restart%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842627%22%20slang%3D%22en-US%22%3ERe%3A%20Powerpivot%20not%20showing%20in%20ribbon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842627%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20thanks%20for%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20the%20steps%20you%20have%20suggested.%26nbsp%3B%20It%20does%20not%20appear%20in%20the%20COM%20addins%2C%20and%20it%20does%20not%20appear%20in%20the%20Disabled%20addin%20section%20either.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20also%20uninstalled%20office%20and%20reinstalled%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20other%20ideas%20I%20can%20try%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Aaron_Griffiths
New Contributor

Hi there

 

Been going round in circles trying to work out why powerpivot isn't showing within excel.

 

Found this link - https://support.office.com/en-us/article/Where-is-Power-Pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b - which seems to indicate that it should be available for any 365 version that has desktop as part of it (mine does - Office 365 Home).

 

There was a lot of posts around the place prior to this year where it looked like powerpivot was NOT a part of Office 365 Home - but the link I put in indicates from 8th January 2019 it should be.

 

Is anyone able to tell me if my Office 365 Home should have PowerPivot or not?  I'm trying to update some work files, but I can't because of th

2 Replies

@Aaron_Griffiths 

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.

Highlighted

@Sergei Baklan  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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies