Fix an Excel Workbook Growing from 2 MB to 94 MB in SharePoint
Question details
Determine why an Excel workbook grew from about 2 MB to 94 MB in SharePoint after a few comments were added.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- A user adds a few short comments to an Excel workbook stored in SharePoint and wants to identify the cause of the size increase.
- Observed behavior
- The workbook grew from a few megabytes to nearly 100 MB, far more than expected for a few short comments.
Note the workbook's displayed size and when it increased. Ask collaborators to pause editing while you download and test a separate copy.
Compare the Downloaded Workbook and Test New Comments
Use this test to determine whether the size increase is in the workbook itself and whether it affects a new file.
In the SharePoint document library, select the workbook, open the three-dot menu, and choose Download. Check the downloaded file's size in your device's file manager.
In Excel, select File > New > Blank workbook. Add a few similar comments using Review > New Comment, save the file, and check its size.
Compare the saved blank workbook with the downloaded SharePoint copy. If only the original grows substantially, investigate hidden content or damage in that workbook.
In SharePoint, open the workbook's three-dot menu and select Version history. If an earlier small version is available, download it if that option is offered, then add similar comments to the separate copy and compare its size.

Check SharePoint Version History and Save a New Copy
Use this approach to distinguish storage used by older versions from the size of the current workbook.
Repair the Workbook and Inspect Hidden Content
Try this if the downloaded workbook is unexpectedly large or grows only when comments are added to that file.
Work with Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing compatible Excel workbooks. It can help you continue spreadsheet work, but it does not fix SharePoint version history or guarantee repair of a damaged Excel file.

Frequently Asked Questions
Can a few Excel comments make a workbook nearly 100 MB?
A few short comments would not ordinarily cause that much growth. Save a blank workbook with similar comments and compare its size with the downloaded original.
Will deleting SharePoint versions shrink the current workbook?
Deleting older versions can reduce version-history storage, but it does not normally reduce the current workbook's contents. Open the file's three-dot menu in SharePoint and select Version history to review versions before deleting any.
How can I tell whether the workbook itself is large?
Select Download from the workbook's three-dot menu in SharePoint, then check the downloaded file's size in your device's file manager.
What if an older version also grows after I add comments?
Test the same comments in a blank workbook. If only copies of the original grow, inspect hidden sheets and embedded content and try File > Open > Browse > Open and Repair in desktop Excel.




