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
MidisG82's avatar
MidisG82
Copper Contributor
Jan 16, 2022

RossKirland 

 

The issue is still present for even through dev option, here is a screenshot. I am on Excel 2016 

  • RossKirland's avatar
    RossKirland
    Copper Contributor
    Jan 16, 2022
    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!

Resources