Open Excel Power Pivot: Enable and Use the Add-In

To open Power Pivot in Excel for Microsoft 365 on Windows, enable its add-in: select File > Options > Add-ins, choose COM Add-ins beside Manage, select Go, check Microsoft Power Pivot for Excel, and select OK. The Power Pivot tab should then appear on the ribbon; select Power Pivot > Manage to open the model window.

Enable the Power Pivot tab in Excel

The add-in is often installed but not active, so enabling it is the first thing to try when you cannot see the tab. In Excel for Microsoft 365 on Windows, use this sequence:

Open Excel and open a workbook, or create a blank one.
Select File, then Options. If a workbook is open, Options is near the bottom of the left-hand navigation.
In the Excel Options window, choose Add-ins.
At the bottom, set the Manage list to COM Add-ins, then select Go.
Check Microsoft Power Pivot for Excel and select OK.

Return to the workbook and look for the Power Pivot tab. Select Power Pivot > Manage to open its separate window, where you can view tables in the workbook’s Data Model and work with relationships and calculations. If the tab does not appear immediately, close and reopen Excel, then check the add-in list again. The exact labels can vary slightly between Office builds, but the COM Add-ins route is the standard Windows method.

If Power Pivot is missing from the add-in list

If Microsoft Power Pivot for Excel is not listed, checking a box cannot install it. Power Pivot availability depends on the Excel product, license, and installation. Some work or school installations are managed by an organization, and an administrator may control which components are available. Check File > Account to identify the product and account in use, and ask your organization’s Microsoft 365 administrator whether the license and installation include Power Pivot. Avoid downloading an add-in from an unofficial site.

If the add-in is listed but disabled or Excel reports that it failed to load, return to File > Options > Add-ins and inspect the Disabled Items list in the Manage menu. If Power Pivot appears there, select it and follow the prompts to re-enable it. A repair of the Office installation may help if the component is damaged, but on a managed computer, contact IT before changing the installation. These steps address different problems: a missing component is not the same as an installed add-in that is switched off.

What Power Pivot does

Power Pivot is Excel’s data-modeling environment. It lets you combine related tables in one workbook, create relationships between them, and analyze their combined data with PivotTables and other Excel features. It is useful when information is stored in separate tables—for example, sales transactions, product descriptions, customer details, and calendar dates—and you want to report across those tables without repeatedly joining or copying their columns together.

The model can hold more data than a traditional worksheet grid can comfortably handle, and it stores data in a compressed, column-oriented model. That can make analysis of large, structured datasets more practical, although the amount a workbook can handle still depends on available memory, data shape, and the computer. Power Pivot is not a replacement for every spreadsheet task: a small, flat list that fits neatly in one table may be easier to analyze with an ordinary PivotTable.

How the Data Model and relationships work

A Data Model is a collection of tables and the connections between them. A typical example has a Sales table containing one row per transaction, a Products table with one row per product, and a Calendar table with one row per date. The Sales table can contain product IDs and dates that match values in the other tables. A relationship allows Excel to use those matching values when a report combines fields from different tables.

For a clean model, the lookup side of a relationship usually needs unique keys: each product ID should appear once in Products, even if it appears many times in Sales. In Excel’s Power Pivot model, relationships are commonly created between a column with unique values in one table and a matching column in another. Mismatched data types, duplicate values on the lookup side, or inconsistent IDs can prevent a relationship from working as intended. For example, the number 104 stored as a number may not match the text value 104 in another table.

Once tables are related, a PivotTable can use a product name from Products alongside a sales amount from Sales. Without a relationship, Excel may not know how the tables connect, and the report can show unexpected totals or fail to offer the fields together. The model is therefore more than a place to store imported tables: its relationships describe how those tables should be interpreted.

Load data and create a useful report

You can add data to the model in more than one way. To add a range already in a worksheet, first format it as an Excel table using Insert > Table or Home > Format as Table. Then select a cell in that table and use Power Pivot > Add to Data Model. The table becomes part of the workbook’s model while remaining available on the worksheet.

For external sources, use Excel’s Data > Get Data tools to connect to a file, database, or other supported source. In the import or load options, choose to load the result to the Data Model when that option is available. The wording and available connectors can depend on the source and Excel build. For a new PivotTable, Excel also provides an option to add data to the Data Model when creating the report; this is useful when the model should include a worksheet table from the start.

A practical workflow for a sales report might be:

Load Sales, Products, and Calendar tables into the workbook’s Data Model.
Check that product IDs and date fields have compatible types and consistent values.
Create relationships between the transaction table and the matching lookup tables.
Insert a PivotTable based on the Data Model, then arrange fields such as product category, year, and sales amount.
Refresh the imported data when the underlying source changes, and check that the report updates as expected.

Power Pivot can also define measures—calculations evaluated in the context of a report. For a table named Sales with a numeric Amount column, a simple measure can be defined as Total Sales = SUM(Sales[Amount]). Add the measure through the Power Pivot measure tools, then use it in a PivotTable. Measures are useful for totals and other calculations that should respond to report filters; they differ from a regular worksheet formula entered into a cell.

Power Pivot, PivotTables, and Power Query compared

These Excel tools often appear together, but they have distinct jobs. Power Query is for connecting to data and preparing it: filtering rows, changing data types, splitting columns, and combining or reshaping sources. Power Pivot is for the Data Model: relating tables and defining measures. A PivotTable is a report interface for summarizing data. A common workflow is to prepare data in Power Query, load it into the Data Model, define relationships or measures with Power Pivot, and present the result in a PivotTable.

Power Pivot is not required for every PivotTable. If all the fields you need are already in one tidy table, a conventional PivotTable may be enough. The Data Model becomes more useful when your report needs fields from multiple related tables, reusable measures, or a structured approach to larger datasets. Conversely, loading unnecessary columns and tables can make a model harder to understand and maintain, so include the data that supports the questions you actually need to answer.

Windows, Mac, and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows, where the Power Pivot COM add-in is managed through Excel Options. The desktop Mac edition does not provide the same Power Pivot add-in and model-management experience, so you should not expect the Windows ribbon steps to work on a Mac. Excel for the web also does not provide the Windows Power Pivot window for creating and managing a model. If you need to build or change a Power Pivot model, use a compatible desktop Excel installation on Windows.

A workbook containing a Data Model may still be relevant to people who use other Excel platforms, but compatibility and the ability to interact with model-based reports can differ. If colleagues will open the workbook on Mac or in a browser, test the specific workbook and reporting features in those environments before relying on them for a shared workflow. For model creation, refresh, or troubleshooting, Windows desktop Excel is the appropriate environment for the steps in this guide.

Common problems and practical checks

When the tab is visible but a report is wrong, the cause may be in the model rather than the add-in. Check that the intended tables were loaded, that relationships use the correct columns, and that lookup keys are unique. Also inspect blank values, inconsistent spellings, and dates stored as text. A relationship can exist and still produce confusing results if the source data does not follow the expected structure.

When a report does not reflect changed source data, refresh the relevant query or PivotTable and confirm that the source file or database is accessible. Imported data does not necessarily update simply because a source worksheet or external file changed. If a refresh fails, check the connection, permissions, file path, and any credentials required by the source. For a workbook that is slow or large, consider whether every imported column is necessary and whether the source can be filtered before loading.

Finally, keep a clear distinction between the worksheet and the model. A table may appear on a sheet but not be included in the Data Model, or a model table may have been loaded without being displayed as a worksheet table. Opening Power Pivot > Manage is a direct way to inspect which tables are actually in the model.

Frequently Asked Questions

How do I open the Power Pivot window in Excel?
Enable Microsoft Power Pivot for Excel under File > Options > Add-ins, using COM Add-ins and Go at the bottom. Then select Power Pivot > Manage on the ribbon.

Why can’t I see Power Pivot in Excel?
The add-in may be switched off, unavailable in your Excel product or license, disabled after an error, or restricted by an organization. Check the COM Add-ins list and Disabled Items first; if Power Pivot is not offered, verify your product and ask your administrator about availability.

Is Power Pivot the same as a PivotTable?
No. Power Pivot manages the Data Model, relationships, and measures. A PivotTable summarizes data for analysis. You can make many PivotTables without Power Pivot, but a model is useful when the report draws on multiple related tables or needs model measures.

Can I use Power Pivot on a Mac or in Excel online?
The Windows Power Pivot add-in and its Manage window are not available in the same way in Excel for Mac or Excel for the web. Use compatible Windows desktop Excel to create and manage a Power Pivot model.

Do I need Power Pivot to use Power Query?
No. Power Query can import and transform data without requiring you to build a Power Pivot model. Power Pivot is useful when you want to load data into a relational Data Model, create relationships, or define measures for analysis.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.