'%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 Export or Download Excel Show Changes History
Question details
The user wants to know how to export or download the audit history from Excel's Show Changes feature into a separate workbook for reporting or review.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Reviewing edits in a shared workbook and needing to extract the full audit history into an external file.
- Observed behavior
- The standard Excel interface displays edits in the Show Changes pane but lacks a direct button or built-in function to export the details to a separate workbook.
Ensure you have access to the Developer tab in Excel to use VBA, and verify if your workbook relies on modern co-authoring or the legacy shared workbook feature.
Use the VBA ListChangesOnNewSheet Property
Since standard Excel does not offer a direct export button, you can use a VBA property available in supported versions to list changes on a new worksheet.
The standard Microsoft Excel interface does not natively support exporting the 'Show Changes' panel information to a separate workbook.
However, in some legacy versions of Excel, you can utilize the VBA Workbook.ListChangesOnNewSheet property. This command attempts to generate a list of recorded changes on a completely new worksheet, which you can then save separately.
Be aware that modern co-authoring environments and Office Scripts often do not support retrieving the complete Show Changes history through macros.
Open your Excel workbook and press ALT + F11 on your keyboard to launch the Microsoft Visual Basic for Applications (VBA) editor.
Press CTRL + G to open the Immediate Window at the bottom of the VBA editor.
Type 'ActiveWorkbook.ListChangesOnNewSheet = True' into the Immediate Window and press Enter.
Return to your Excel workbook. If successful, a new worksheet will be created containing the list of changes. You can right-click this sheet tab to move or copy it to a new, separate workbook.
Try WPS Office for Seamless Spreadsheet Management
If you are frustrated by the limitations of Excel's built-in version history tools and macros, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with comprehensive spreadsheet tools.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your device.
- 2. Install the Application: Run the installer and follow the quick on-screen instructions to set up the software.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files with full formatting and feature compatibility.
Frequently Asked Questions
Can I use Office Scripts to export the Show Changes history in Excel Online?
Currently, there is no supported Office Script or macro that can retrieve all the detailed information displayed by the modern Show Changes feature in Excel Online.
Why did the 'ActiveWorkbook.ListChangesOnNewSheet' VBA command fail?
This VBA property relies on the older 'Track Changes (Legacy)' feature. If your workbook uses the modern cloud-based co-authoring 'Show Changes' system, this macro may fail or return incomplete data.
Is there any manual workaround to save the changes history in modern Excel?
Without a built-in export option, users typically have to resort to taking screenshots of the Show Changes pane or manually copying critical edit logs into a separate document for auditing purposes.
Does WPS Office support Excel's Track Changes features?
Yes, WPS Spreadsheets supports tracking changes and provides high compatibility with Microsoft Excel's document formats, allowing you to seamlessly review edits in shared workbooks.
