Forum Discussion

Aaron_Griffiths's avatar
Aaron_Griffiths
Copper Contributor
Sep 06, 2019

Powerpivot not showing in ribbon

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-4b6...
office 365
RossKirland's avatar
RossKirland
Copper Contributor
Jan 11, 2022

I appreciate some time has passed but I hope this helps someone. To solve the issue of missing Power Pivot tab:

  1. File>Options>Ad-ins
  2. Highlight Microsoft Power Pivot for Excel (+ any additional options you find useful)
  3. Click Go...
  4. If Power Pivot tab is still missing from the working environment then on the excel ribbon, go to: Developer>Com Add-ins
  5. Check the boxes for the Add-ins you want to enable (including Microsoft Power Pivot for Excel)
  6. Click Ok and the tab should appear
BarnabyJ's avatar
BarnabyJ
Copper Contributor
May 14, 2023

RossKirland 

 

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.

Resources