File Corruption & Recovery

Fix an Excel Workbook Growing from 2 MB to 94 MB in SharePoint

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

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

Why Does an Excel Workbook Grow from 2 MB to 94 MB in SharePoint?
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.
Before you start

Note the workbook's displayed size and when it increased. Ask collaborators to pause editing while you download and test a separate copy.

Solution 1Recommended

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.

1
Download the workbook

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.

2
Test a blank workbook

In Excel, select File > New > Blank workbook. Add a few similar comments using Review > New Comment, save the file, and check its size.

3
Compare the results

Compare the saved blank workbook with the downloaded SharePoint copy. If only the original grows substantially, investigate hidden content or damage in that workbook.

4
Test a separate earlier copy

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.

Compare the Downloaded Workbook and Test New Comments
Comments alone should use little space: A few short comments would not ordinarily explain tens of megabytes of growth. If an earlier copy also grows immediately, the underlying workbook may contain hidden content or be damaged.
Free Microsoft Office alternative

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.

Open and edit spreadsheet content in a familiar interface.Compatible with Microsoft Excel formats such as XLSX and XLS.Save a separate workbook copy for size comparison.Move compatible Office files into a lightweight, easy-to-use suite.
microsoft office alternative - wps office

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.