Microsoft Excel — "Not enough system resources to display completely" — What It Means & How to Fix It

What Does This Error Mean?

This error means Excel is trying to show you a spreadsheet but your computer does not have enough resources to display all of it at once. Excel can still work, but some rows, columns, or charts may appear blank or cut off. It is a warning — not a crash — but it means the spreadsheet is pushing your PC's limits.

Affected Models

Microsoft Excel 2016
Microsoft Excel 2019
Microsoft Excel 2021
Microsoft 365 Excel

Common Causes

The spreadsheet contains a very large number of rows, columns, or worksheets
Many complex formulas are recalculating at the same time
The file contains dozens of charts, images, or embedded objects
Too many other programs are open and competing for your PC's RAM
You are using a 32-bit version of Office, which has a lower memory ceiling than the 64-bit version

How to Fix It

Close all other open programs — browser tabs, Outlook, Teams, everything — and then reopen the Excel file.

Every open program uses RAM. Clearing them out gives Excel more room to work with.
Check if you are running 32-bit or 64-bit Office. Open any Office app, go to File > Account > About Excel. If it says 32-bit, consider upgrading to the 64-bit version.

32-bit Office can only use about 2 GB of RAM. The 64-bit version can use much more, which fixes this error on large files.
Split the spreadsheet into smaller files. Move some worksheets into separate workbooks to reduce the load on any one file.

A single file with 50 worksheets will always struggle. Two files with 25 worksheets each will be much more manageable.
Turn off automatic calculation temporarily. Go to Formulas > Calculation Options > Manual. This stops Excel from recalculating everything every time you type.

Complex formulas recalculating constantly is a major resource drain. Switch back to Automatic when you are done editing.
Delete or compress any images in the spreadsheet. Click on an image, go to Picture Format > Compress Pictures, and reduce the resolution.

Embedded images are often the hidden cause of bloated Excel files. Removing unneeded images can cut file size by 80% or more.

When to Call a Professional

If you regularly work with very large spreadsheets and keep hitting this error, an IT professional can assess whether your PC needs more RAM. They can also help you migrate from 32-bit Office to 64-bit Office, which significantly raises the memory ceiling. Expect one to two hours of IT labor for this type of upgrade.

Frequently Asked Questions

Will I lose data if I see this error?

Usually not. The error is a display warning, not a data corruption notice. Your data is still there — Excel just cannot render all of it on screen at once. Save your work immediately and then try the fix steps above.

How do I know if I have 32-bit or 64-bit Office?

Open Excel, click File, then Account, then click the About Excel button. In the title of the window that opens, you will see either '32-bit' or '64-bit' in parentheses. If you see 32-bit and you regularly work with large files, upgrading to 64-bit will make a big difference.

My spreadsheet only has a few thousand rows — why is this happening?

Row count alone is not always the culprit. A spreadsheet with thousands of complex formulas, many charts, or dozens of embedded images can hit resource limits even with a modest number of rows. Check for hidden sheets, embedded objects, and overly complex formulas that may be hidden from view.