'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Preserve Excel Change History for Monthly Copies in Teams
Question details
The user needs a reliable method to retain the version history of an Excel file when creating monthly copies in Microsoft Teams or SharePoint for auditing purposes.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating monthly copies of an Excel tracking or reporting file while needing to maintain a complete history of edits for compliance and audit trails.
- Observed behavior
- When an Excel file is copied in Teams or SharePoint, the new copy does not retain the original file's version history, resulting in a loss of historical audit data.
Ensure you have the necessary permissions (Owner or Member role) in your Microsoft Teams channel or SharePoint document library to access and modify library settings.
Keep the Original File as the Master Audit Record
Because copying a file drops its historical data by design, the best approach is to continue working in the original file and use SharePoint's built-in versioning to track changes over time.
In the Microsoft 365 ecosystem, a copied file is treated as a brand-new entity, meaning all previous version history is left behind in the original file. To maintain a strict audit trail, you must structure your workflow around the original document rather than working out of newly created monthly copies.
Navigate to the Teams channel where your file is saved, click the three dots (...) at the top right, and select 'Open in SharePoint'. Click the Gear icon (Settings) and select 'Library settings', then 'More library settings'.
Click on 'Versioning settings' under General Settings. Ensure that 'Create major versions' is selected. You can specify the number of versions to retain (up to 50,000) to ensure older monthly changes are never deleted.
Instead of duplicating the file to create a new working copy for the month, generate a manual copy only for archival or read-only distribution. Continue making all active, ongoing updates in the original source file so its continuous version log remains unbroken.
Try WPS Office for Seamless Document Management and Version Tracking
If Microsoft Teams and Excel version history limitations disrupt your auditing workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with its own robust WPS Cloud capabilities to track historical changes effortlessly.
- 1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
- 2. Open Your Excel Files: Launch WPS Spreadsheet and open your existing .xlsx files with complete formatting compatibility.
- 3. Utilize WPS Cloud: Enable WPS Cloud backup to automatically save your changes and securely track the document's version history over time.
Frequently Asked Questions
Why does my copied Excel file lose its version history?
When you create a copy of a file in SharePoint, Teams, or OneDrive, the system treats the copy as a completely new document. Therefore, the historical edits, previous versions, and author metadata from the original file are not duplicated into the new copy.
How do I view a previous version of an Excel file in Teams?
Open the file in the Excel desktop application or Excel for the Web. Go to File > Info > Version History. A pane will appear on the right side of the screen displaying previous versions, which you can click to view or restore.
Is there a limit to the number of versions SharePoint can store?
Yes, by default, SharePoint modern document libraries are configured to store the last 500 major versions of a file. A site administrator can adjust this limit in the Library Settings up to a maximum of 50,000 versions, depending on the organization's compliance requirements.
Can I merge the version histories of two different Excel files?
No, Microsoft Excel and SharePoint do not support merging the version histories of two separate files natively. If you have been working across two different copies, their audit trails will remain permanently separated.
