Fix an Excel Online Workbook That Grows Too Large After Saving
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.
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.
Restore a smaller workbook version
Use Version history to recover a copy from before the unexpected size increase.
In OneDrive or SharePoint, find the workbook, select its three-dot menu, and choose Version history.
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.
In Version history, choose Restore for the verified version. Check that any needed changes from later versions are accounted for before restoring.
Remove unnecessary content in desktop Excel
Use this approach if a workbook version can be opened in desktop Excel and still needs to be reduced.
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.

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.




