-
Go to File > Options.
-
Go to Add-ins, under the Manage drop-down list, choose COM Add-Ins and select Go.
-
Check Microsoft Power Pivot for Excel, and select OK
Power Pivot isn't currently available on Excel for Mac. You can however use the Power Query editorImport and shape data in Excel for Mac (Power Query).
for easy data gathering and shaping capabilities. Power Query enables you to connect, combine, and refine data sources to meet your analysis needs. For more info, seePower Pivot isn't currently available in Excel for the web. You can, however, use Power Pivot in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.