Excel Data Model on Mac: What Works and What Doesn’t

How-to basics · Updated November 18, 2026

Excel for Mac does not include Power Pivot, so you cannot create, manage, or refresh a full Excel Data Model on a Mac the way you can in Excel for Windows. You can still use regular PivotTables and some Power Query features, but for a workbook that depends on relationships, DAX measures, or the Data Model, use Excel for Windows or another modeling tool.

What the Excel Data Model is

The Data Model is a way to connect multiple tables inside an Excel workbook and analyze them together. Instead of putting every field into one large, repeated spreadsheet, you can keep related information in separate tables and define how those tables relate. The model can then supply fields to a PivotTable or PivotChart as if they came from one connected source.

For example, a sales workbook might contain a Sales table with transaction dates, product IDs, and quantities, plus a Products table with product IDs, names, and categories. A relationship between the two tables lets a report show sales by product category without copying the category into every sales row. A calendar table could add year, quarter, or month groupings.

On Windows, the model is commonly managed through Power Pivot. It can store data, relationships, and DAX calculations such as measures that calculate total sales or year-to-date sales. A normal PivotTable made from one worksheet range is different: it can summarize that range, but it does not provide the same multi-table model or Power Pivot tools.

What works in Excel for Mac

Excel for Mac remains useful for many spreadsheet tasks. You can create and use ordinary PivotTables from a table or cell range, sort and filter data, build charts, and work with formulas. Those features do not require the Power Pivot Data Model. If all the fields needed for a report are in one clean table, a regular PivotTable may be sufficient.

Power Query is also available in Microsoft 365 versions of Excel for Mac, although feature availability and the interface can differ from Windows and change with updates. It can help import, clean, and reshape data. That does not mean the Mac edition has Power Pivot: the important limitation is that Power Query results cannot be loaded into and managed as a full Excel Data Model on Mac.

In short, a Mac can be part of a data-preparation or reporting workflow, but it is not a substitute for Windows Power Pivot when the workbook needs model relationships and DAX. Check the current Microsoft documentation for your exact Excel build if a particular connector or query operation matters, since Power Query capabilities are not identical on every platform.

What Mac cannot do with a Data Model

Excel for Mac does not provide the Power Pivot authoring environment. In practical terms, you cannot use the Mac app to build and maintain the model features that require that environment. These include creating model relationships between separate tables, managing model tables in Power Pivot, and authoring DAX measures as part of the workbook’s Data Model.

  • You cannot use the Power Pivot window to inspect or manage model tables on Mac.
  • You cannot build a model-based PivotTable by adding source tables to the Data Model as you can in Excel for Windows.
  • You cannot rely on Mac Excel to refresh or edit model-based calculations and relationships.
  • You should not assume that a workbook with model-backed reports will behave identically after opening or saving it on Mac.

Some workbooks created on Windows may open on a Mac and display saved worksheet values or report output. That is not the same as having a supported, editable model. Depending on the workbook and the operation, a model-backed PivotTable may be limited, show an incomplete result, or fail to refresh. Keep an untouched copy and test a noncritical copy before making changes to a Windows-authored file.

How the Windows workflow differs

On Excel for Windows, you can create a Data Model from supported sources and use Power Pivot to work with it. For example, when creating a PivotTable, Windows Excel offers an option to add data to the Data Model. The Power Pivot tab and its Manage command provide access to the model when the add-in is available. The exact route depends on how the data is connected and the Excel edition, but those model-authoring tools are not present in Excel for Mac.

A typical modeling workflow on Windows looks like this:

  1. Prepare separate, well-structured tables, with a unique key in each lookup table and matching key values in the related data table.
  2. Load the tables into the Data Model, using Power Pivot or the available import and PivotTable options.
  3. Create relationships between matching key columns, such as Products[ProductID] and Sales[ProductID].
  4. Create DAX measures for calculations that should respond to report filters, then build PivotTables or PivotCharts from the model.
  5. Save the workbook and test its refresh and reporting behavior on the computers that will use it.

Those steps describe the Windows workflow, not a set of Mac menu commands. If the source data changes, the Windows user responsible for the model should refresh and validate it there. A Mac user can then use supported workbook content where possible, but should not be assigned model maintenance that requires Power Pivot.

Choosing a practical Mac workflow

Start by deciding whether the report genuinely needs a Data Model. If there is one source table, or if a small number of sources can be combined into a single tidy table, a regular PivotTable may solve the problem. Avoid adding model complexity just because a workbook contains a PivotTable: the deciding factor is whether the analysis needs multiple related tables, reusable measures, or model-scale data handling.

If you do need to transform several sources, Power Query on Mac may be able to perform the preparation you need. You can then load the result to a worksheet and build an ordinary PivotTable, provided the resulting table is manageable and contains the columns the report needs. This approach can duplicate values and make the workbook larger, so it is not always a good replacement for a relational model.

When the model is essential, arrange access to Excel for Windows for the person who creates, refreshes, and validates it. That may mean using a Windows computer at work, a properly licensed Windows virtual machine, or asking a colleague with Windows Excel to maintain the file. Before choosing a setup, confirm that it is permitted by your organization and that your Microsoft 365 plan and device support it.

Opening a Windows model workbook on a Mac

If someone sends you an Excel workbook that uses Power Pivot, ask what you need to do with it. Reading a static summary is a different requirement from refreshing data, changing a relationship, or building a new model-based PivotTable. A workbook can retain visible values even when the Mac app cannot update the underlying model that produced them.

For safer collaboration, agree on a division of work. A Windows user can own model changes and refreshes; Mac users can review exported reports or update other parts of the workbook that do not depend on unsupported features. If a Mac user edits and saves the original, confirm the model and PivotTables still work in Windows before treating that saved file as the new master.

  • Keep a backup of the original Windows workbook.
  • Ask the owner whether displayed figures are current or merely saved results from the last refresh.
  • Do not remove, replace, or rebuild model-backed PivotTables on Mac without checking the effect in Windows.
  • For a report that must be widely readable, consider distributing a PDF or a separate values-only report alongside the working workbook.

Alternatives to Power Pivot on a Mac

The best alternative depends on the size of the data and whether users need an editable model or simply a finished report. A single-table PivotTable is the simplest option. Power Query can prepare data for that table where the Mac version supports the required sources and transformations. For more advanced analysis, consider tools that support your platform and collaboration needs.

  • Excel for Windows: The most direct choice when compatibility with an existing Excel Data Model and Power Pivot workbook is required.
  • Power BI: Power BI Desktop is a Windows application, so a Mac user generally needs a Windows environment to author a Desktop model. Power BI Service runs in a browser for viewing and collaboration, but it is not a Mac version of Power Pivot in Excel.
  • A database or data platform: If multiple people need governed, reusable data, a database can hold the relationships and calculations, with Excel used for supported analysis or exports.
  • A single prepared table: For modest reporting needs, a cleaned, consolidated table and a standard PivotTable may be easier to maintain than a multi-table model.

Before moving to another tool, check how data is refreshed, who can access it, and whether the final report needs to remain an Excel workbook. A solution that works on one Mac may not be suitable for a team that must refresh the same model on Windows or share it through a managed service.

Common misconceptions and problems

Power Query is not Power Pivot. They are related but do different jobs. Power Query imports and transforms data; Power Pivot provides the Excel modeling environment for relationships and DAX. Seeing a Get Data or query feature in Mac Excel does not mean the Data Model is supported.

A PivotTable is not automatically a Data Model PivotTable. A PivotTable based on one worksheet table is supported as a regular Excel feature. A report built from multiple related model tables depends on capabilities that Mac Excel does not provide for authoring and maintenance.

Saved figures do not prove that refresh works. If a workbook opens and shows numbers, those numbers may reflect the last successful refresh on Windows. Confirm the refresh status and compare the report with its source data before using it for a decision. If refresh is unavailable on Mac, have the model owner refresh it in a supported Windows version.

Compatibility is not the same as support. Opening a file without an obvious warning does not establish that all model features survived an edit or save. For important workbooks, preserve the Windows master and verify any modified copy in the environment where its Data Model is maintained.

Frequently Asked Questions

Does Excel for Mac have Power Pivot?
No. Excel for Mac does not include the Power Pivot authoring tools available in Excel for Windows. It therefore cannot create and maintain a full Excel Data Model with the same relationships and DAX workflow.

Can I create a Data Model in Excel for Mac?
Not with the full Power Pivot Data Model functionality. You can use regular PivotTables and supported Power Query features, but those are not a way to author a multi-table Power Pivot model on Mac.

Can Excel for Mac open a workbook made with Power Pivot?
It may open the workbook and show some saved worksheet or report output, but model-backed features are not fully supported for Mac authoring and refresh. Keep a backup and verify important changes in Excel for Windows.

Can Power Query on Mac replace the Data Model?
Not by itself. Power Query can import and transform data where the Mac version supports the operation, but it does not provide the relationships and DAX modeling tools of Power Pivot. Loading transformed data to a worksheet and using a regular PivotTable is a simpler, more limited alternative.

What should I use instead on a Mac?
Use a regular PivotTable if one prepared table meets the need. If the workbook requires relationships and DAX, use Excel for Windows to maintain it, or choose a platform designed for the required data model and team workflow.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.