Fix Excel File Size Fluctuations in SharePoint Version History
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.

- 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.
Ensure you have Site Owner or Member permissions in the SharePoint document library, as you will need access to modify library versioning settings.
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.
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'.
Click on 'More library settings', then select 'Versioning settings' under the General Settings column.
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.
Click 'OK' to apply the new versioning rules. Monitor the file size over the next few co-authoring sessions.

Allow Time for Co-authoring Consolidation
Concurrent edits often create temporary parallel copies behind the scenes. Waiting for all users to exit the file allows SharePoint to properly consolidate the data.
Test Alternative Files and Environments
Isolating the issue ensures the problem isn't caused by a corrupted workbook or specific site configuration.
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. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Upload to WPS Cloud: Save your spreadsheets directly to WPS Cloud for streamlined, optimized co-authoring.
- 3. Collaborate Reliably: Share the secure file link with your team to edit simultaneously without excessive versioning bloat.

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.




