How to Enable & Disable Power Pivot Add-In in Excel
The Power Pivot is an add-in for Microsoft Excel. This add-in is used extensively for powerful data analysis by creating Pivot Tables. However, Power Pivot is not a default program in Excel. You need to enable it manually to start using this tool. Well, this article will guide you to enable and disable the Power Pivot add-in in Excel.
What is Power Pivot in Excel?
Power Pivot is a Microsoft Excel add-in that allows users to perform advanced data analysis and develop advanced analytical models. It is a built-in Excel tool for assessing huge data sets.
Users can import data from a variety of sources, including databases, spreadsheets, and text files, using Power Pivot. They can then use Pivot Tables, Pivot Charts, and other data visualization tools to analyze the data.
Users can also establish connections between sets of data with Power Pivot, which can be used to create comprehensive data models. These data models can be used to solve complex data queries.
Power Pivot Features
- Supports importing data from various sources such as databases, text files, Excel files, various spreadsheets,
- It can handle large data files up to 2GB.
- While importing data, it supports filtering data and renaming data tables and column headers.
- Creates relational data model among different data tables.
- Supports DAX (Data Analysis Expressions) language to write complex formulas.
- Generates KPIs (Key Performance Indicators).
Power Pivot Add-In Availability in Excel
The Power Pivot add-in is included in the recent versions of MS Excel. The older version of MS Excel is still missing out on this data analysis tool.
However, you will get the Power Pivot add-in included in MS Excel 2013 and later versions. But you won’t find this add-in enabled. You have to manually activate this add-in to start working with it.
In Microsoft Excel 2010, you can still use the Power Pivot add-in. But unfortunately, this add-in this not included with the official office product. You have to download the add-in first.
Unfortunately, the Power Pivot add-in is missing in older versions of MS Excel such as Excel 2007, Excel 2003, and so on.
Enable Power Pivot Add-In in the Main Ribbon in Excel
If you are using MS Excel 2013 or the later versions, follow this guide to activate the Power Pivot add-in.
Step_1: Select the File menu.
Step_2: Select Options.
Step_3: Select Add-ins in the Excel Options dialog box.
Step_4: Choose COM Add-ins from the Manage drop-down.
Step_5: Now click on Go.
Step_6: Mark a tick beside the Microsoft Power Pivot for Excel option in the COM Add-ins dialog box.
Step_7: Click OK.
Check your Excel ribbon. You will find the Power Pivot menu in the main ribbon after the Help tab.
🔗 2 Ways to Add Developer Tab in Excel
Disable Power Pivot Add-In in the Main Ribbon in Excel
If you want to remove the Power Pivot add-in from the main menu in Excel,
Step_1: Click the File tab.
Step_2: Select Options.
Step_3: Select Add-ins in the Excel Options dialog box.
Step_4: Select COM Add-ins in the Manage drop-down.
Step_5: Click the Go button to proceed with the selection.
Step_6: Deselect Microsoft Power Pivot for Excel in the COM Add-ins dialog box.
Step_7: Click OK.
Excel will remove the Power Pivot add-in from the main ribbon. You can check it next to the Help tab.
[Solved] Power Pivot is Missing?
The Power Pivot is a heavy-weight data analyzing tool. You can literally support large data files up to 2GB. Such a powerful tool like Power Pivot when closed unexpectedly while the window is open, can prompt the Excel program unstable. Thus, Excel can disable the Power Pivot.
If such a case occurs and you can’t find the Power Pivot ribbon in the menu, follow along with the guide.
Method #1: Using the Disabled Items to Restore Power Pivot Ribbon
Step_1: Go to the File menu.
Step_2: Select Options.
Step_3: Select Add-ins in the Excel Options dialog box.
Step_4: From the Manage drop-down choose Disabled Items.
Step_5: Then hit Go.
Step_6: From the Disabled Items dialog box, select Microsoft Office Power Pivot and click Enable.
This will restore the Power Pivot in your Excel program.
But, if this method doesn’t work for you, try the next method.
Method #2: Using Registry Editor to Restore Power Pivot Ribbon
Step_1: Type Run in the Windows search box.
Step_2: Then click Open.
You can also press the WIN + R buttons to open the Run dialog box.
Step_3: Type
regedit
in the box beside Open and hit OK.
Registry Editor appears.
Step_4: Navigate the following path.
For Excel 2013: HKEY_CURRENT_USER ⋙ Software ⋙ Microsoft ⋙ Office ⋙ 15.0 ⋙ User Settings.
For Excel 2016: HKEY_CURRENT_USER ⋙ Software ⋙ Microsoft ⋙ Office ⋙ 16.0 ⋙ User Settings.
Step_5: You will find PowerPivotExcelAddin under the User Settings. Right-click on it and select Delete.
Step_6: Now navigate the path: HKEY_CURRENT_USER ⋙ Software ⋙ Microsoft ⋙ Office ⋙ Excel ⋙ Addins.
Step_7: This time select PowerPivotExcelClientAddIn.NativeEntry.1. Right-click on it and select Delete again.
Step_8: After that, close the Registry Editor dialog box.
Step_9: Now open the Excel program.
Step_10: Again enable the Power Pivot add-in and enjoy!
Conclusion
I’ve discussed how to enable and disable the Power Pivot add-in in Excel. I’ve also discussed the restoring techniques of the Power Pivot add-in if Excel disables it by itself. I expect you’ve found this article useful. You can read more articles relating to Excel from the Blog page of our website. Have a fantastic workday!