Version History Issues

Fix Excel File Size Fluctuations in SharePoint Version History

Amos GikundaAmos Gikunda Nov 2, 2026 868 views

Question details

Users experience dramatic file size fluctuations (sometimes up to a tenfold increase) in Excel workbooks stored in Teams or SharePoint during simultaneous co-authoring.

Fixing Excel File Size Fluctuations in SharePoint Version History
Product
Microsoft Excel / SharePoint
Device & OS
not provided
Scenario
Multiple users are co-authoring an Excel workbook simultaneously from a SharePoint document library or Microsoft Teams.
Observed behavior
The file size in the SharePoint Version History fluctuates significantly between versions, often inflating massively before returning to normal.
Before you start

Ensure you have Site Owner or Member permissions in the SharePoint document library, as you will need access to modify library versioning settings.

Solution 1Recommended

Adjust SharePoint Document Library Versioning Settings

Changing how SharePoint handles versions can prevent the system from saving a massive, redundant file for every single minor edit.

If your library is configured to create a major version for every single change, simultaneous co-authoring will rapidly generate large historical files. Modifying these limits can mitigate sudden storage bloat.

1
Open Library Settings

Navigate to the SharePoint document library where the Excel file is stored. Click the Gear icon (Settings) in the top right corner and select 'Library settings'.

2
Access Versioning Settings

Click on 'More library settings', then select 'Versioning settings' under the General Settings column.

3
Modify Version Limits

Under 'Document Version History', ensure that the number of versions to retain is set to a reasonable limit (e.g., 100). If minor versions are not needed, ensure only major versions are tracked.

4
Save Changes

Click 'OK' to apply the new versioning rules. Monitor the file size over the next few co-authoring sessions.

Adjust SharePoint Document Library Versioning Settings
Historical Versions: Changing this setting applies to future edits. You may need to manually delete previously generated large versions from the file's Version History menu to free up space.
Free Microsoft Office alternative

Try WPS Office for Seamless Collaboration and File Management

If SharePoint and Excel versioning issues are disrupting your team's workflow, consider WPS Office. It provides a lightweight, highly compatible alternative with its own reliable cloud collaboration tools designed to keep file sizes optimized.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Upload to WPS Cloud: Save your spreadsheets directly to WPS Cloud for streamlined, optimized co-authoring.
  3. 3. Collaborate Reliably: Share the secure file link with your team to edit simultaneously without excessive versioning bloat.
Free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Excel (.xlsx) formatsStable cloud co-authoring without unpredictable file size bloatingFamiliar user interface for quick, seamless migration
microsoft office alternative - wps office

Frequently Asked Questions

Why does simultaneous editing increase file size in SharePoint?

When multiple users edit an Excel file concurrently, SharePoint may create temporary parallel copies behind the scenes to prevent data loss. Once everyone closes the file, these changes are consolidated, which typically reduces the final file size back to normal.

How do I delete large version history files in SharePoint?

Navigate to your SharePoint document library, click the three vertical dots next to your Excel file, select 'Version history', and click the dropdown arrow next to the date of a specific large version. Select 'Delete' to remove it and free up storage space.

Can 'Track Changes' cause Excel file bloat?

Yes. If Legacy Track Changes is enabled in Excel, keeping a detailed log of every cell change can significantly increase the workbook's file size over time. Consider accepting changes and clearing the history periodically.

Does this size fluctuation issue affect Word or PowerPoint files too?

While it can happen with any Office file type, it is most noticeably reported with Excel workbooks due to how Excel handles complex grid calculations and metadata during co-authoring syncs.