Maximum Memory or File Size Exceeded

This message appears when the maximum memory or file size limit for a Data Model is exceeded. In the 32-bit version of Office, the maximum files size for a workbook containing a Data Model is 2 GB, and the maximum memory that can be consumed by a workbook is 4 GB. If you exceed either of these limits, the workbook cannot be saved.

If this occurs, you must reduce the number of tables, rows, or columns that are linked, imported, or copied to the Power Pivot window before you can save the workbook. There are two ways to do this:

Filtering data that has already been imported (as described in Filter Data in DAX Formulas) is not a solution for this error. Filtering imported data only affects how data is displayed.

Top of Page

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.