Excel Performance Problems

How to Fix Excel Data Model Memory Error from Oversized Records

Bushra Parveen Sep 27, 2026 869 views

Question details

The user needs to resolve an error stating that a record exceeds the maximum page size when refreshing the Excel Data Model.

How to Fix Excel Data Model Memory Error Caused by an Oversized Record

Product: Microsoft Excel
Device & OS: not provided
Scenario: Importing large datasets or refreshing the Data Model with wide tables and extensive text fields.
Observed behavior: Excel displays a memory error indicating that an imported record is too large for the storage engine and fails to refresh the Data Model.

Before you start

Before modifying your data structure, inspect your source data to identify any unusually large text fields or unnecessary columns, as these are the most common culprits for exceeding the page size limit.

Solution 1Recommended

Reduce Imported Data Size Using Power Query

The most effective way to resolve this error is to minimize the footprint of your imported records by removing non-essential data before it reaches the Data Model.

The Excel Data Model runs on the Analysis Services engine, which imposes a strict 8 KB limit on page size. If a single row of data exceeds this limit due to wide columns or long strings of text, the refresh will fail.

Open Power Query Editor

Navigate to the 'Data' tab on the Excel ribbon, click on 'Get Data', and select 'Launch Power Query Editor'.

Remove Unnecessary Columns

Review your dataset for columns that are not required for your pivot tables or analysis. Right-click the header of any unneeded column and select 'Remove'.

Filter Out Unused Rows

Click the drop-down arrow on relevant column headers (such as dates) and apply filters to exclude data that falls outside your required analysis scope.

Shorten Large Text Fields

If you have descriptive text columns, consider using the 'Extract' or 'Split Column' tools in Power Query to truncate the text or keep only the necessary identifiers.

Load and Refresh

Click 'Close & Load' to apply the changes. Refresh your Data Model to verify if the memory error has been resolved.

Reduce Imported Data Size Using Power Query

Testing Changes: Refresh the Data Model after each major structural change in Power Query. This incremental approach helps you pinpoint exactly which field was causing the oversized record error.

Solution 2

Split the Source Data into Smaller Relational Tables

If you cannot delete large text fields because they are required for your work, splitting a massive flat table into smaller relational tables can bypass the page size limit.

Free Microsoft Office alternative

Experience Smooth Data Handling with WPS Office

If you frequently encounter performance issues, memory limits, or complex errors when working with large datasets in Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and robust alternative for managing your spreadsheets seamlessly.

1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and click 'Open' to load your existing .xlsx or .csv files instantly without any formatting loss.
3. Analyze Data Smoothly: Utilize built-in pivot tables and filtering tools to process your large datasets with optimized memory performance.

Fully compatible with Microsoft Office spreadsheet formats including .xlsx, .xls, and .csvLightweight architecture ensures faster startup times and smoother scrolling through large datasetsFree to use with a familiar, easy-to-navigate tabbed user interfaceBuilt-in advanced data analysis and visualization tools to streamline your workflow

microsoft office alternative - wps office

Frequently Asked Questions

What does 'record exceeds the maximum page size' mean in Excel?

This error occurs because the underlying Analysis Services storage engine used by the Excel Data Model has a strict 8 KB page limit. If a single row of your imported data exceeds this size—typically due to extremely long text strings or too many columns—the system cannot process the record.

Can I increase the memory limit or page size for the Excel Data Model?

No, the maximum page size is hardcoded into the data storage engine and cannot be manually increased. You must resolve the issue by optimizing your dataset, such as removing columns or splitting tables.

Does shortening text fields actually help fix Data Model errors?

Yes. Text fields consume significantly more memory per character compared to numerical data. Truncating long descriptions or moving them to a separate linked table is one of the most effective ways to reduce record size and avoid memory errors.

Excel & Data Problems