Excel Performance Problems

Fix an Excel Online Workbook That Grows Too Large After Saving

Tauseeq MagsiTauseeq Magsi Nov 22, 2026 868 views

Question details

The user needs to understand and reduce a workbook that grew substantially after being saved in Excel Online.

Product
Microsoft Excel Online
Device & OS
not provided
Scenario
A workbook was saved without apparent edits and is now too large to use in Excel Online.
Observed behavior
The workbook increased from about 204 MB to 6,000 MB and exceeds the Excel Online file-size limit.
Before you start

Check the file size in OneDrive or SharePoint and see whether Version history contains a smaller version from before the save. You may need desktop Excel to inspect and reduce workbook content if the current file cannot open in Excel Online.

Solution 1Recommended

Restore a smaller workbook version

Use Version history to recover a copy from before the unexpected size increase.

1
Open version history

In OneDrive or SharePoint, find the workbook, select its three-dot menu, and choose Version history.

2
Find an earlier version

Review the available versions and select one saved before the size increase. Download or open it if that option is available so you can check its contents and size.

3
Restore the version

In Version history, choose Restore for the verified version. Check that any needed changes from later versions are accounted for before restoring.

Check the restored file size: Restoring an earlier version may recover the smaller file, but it does not change Excel Online's file-size limits.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheet to continue your work, though it cannot change Excel Online's file-size limits or guarantee that an exceptionally large workbook will open.

Work with spreadsheets in a familiar, easy-to-use interfaceOpen and save compatible Microsoft Excel XLSX files for easier migrationInspect and remove unnecessary spreadsheet content when the file opensUse a free, lightweight Office alternative
QA img-9

Frequently Asked Questions

Why did my workbook grow even though I did not make apparent edits?

Excess formatting, unused cells, embedded objects, hidden content, or damaged workbook data can contribute to bloat. Compare versions in OneDrive or SharePoint Version history to identify when the size changed.

Can I increase the Excel Online file-size limit?

Excel Online has service file-size limits that users cannot change. Restore a smaller version or reduce the workbook in desktop Excel before trying to open it online again.

How do I find a workbook's last used cell?

Open the workbook in desktop Excel, select a worksheet, and press Ctrl+End. If the last used cell is far beyond the data, inspect the extra rows and columns before deleting them.

What if the 6,000 MB workbook will not open in desktop Excel?

In OneDrive or SharePoint, open the file's three-dot menu and choose Version history. Try downloading an earlier, smaller version that can be opened and checked.