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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!