09-16-2020 08:56 PM
09-16-2020 08:56 PM
I subscribed to Microsoft 365
Does anyone know if - and how - is possible to subscribe or receive the Excel Power Pivot and Power Query add-ons?
09-17-2020 05:14 AM
These are no longer add-ins. They come with Office365. Power Pivot has its own tab. If you don't see this tab (see next)
Use File > Options > Customize Ribbon and make sure Power Pivot is checked
PowerQuery is 'hidden' in the Data tab in the Get & Transform Data group
Hope that helps
09-17-2020 06:25 AMSolution
Hello @fabiodiprimaoutlook ,
You will need to ensure the Microsoft Power Pivot add-in within Excel is enabled.
Kindly launch Excel with administrator privileges.
Go to File > Options > Add-Ins.
In the Manage box, click COM Add-ins> Go.
Check the Microsoft Office Power Pivot box, and then click OK. If you have other versions of the Power Pivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the Power Pivot add-in for Excel.
Power Pivot is an add-in that is built into some versions of Office. This is usually used when performing a complex data analysis in Excel. Regarding your concern, can you confirm if the Power Pivot ribbon was the one that got removed or was it the actual Power Pivot add-in was removed from the list of add-ins in Excel?
In the meantime, here’s how Power Pivot is enabled before using it for the first time:
To restore the Power Pivot menu, please follow these steps:
Just in case that the previous steps were not able to restore the Power Pivot ribbon, or if the ribbon itself disappears when you close and open the Excel again, try these:
Important: This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, refer to the following Microsoft Knowledge Base article: How to back up and restore the registry in Windows.
Let us know if the steps provided have resolved your concern.