How to Stop Excel from Sharing Undo and Redo History Across Workbooks
Question details
Users want to know why Microsoft Excel shares a single undo and redo history across multiple open workbooks, and how to separate them so undoing an action in one workbook doesn't affect another.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Editing multiple Excel workbooks simultaneously and attempting to undo a mistake in one of them.
- Observed behavior
- Pressing Undo (Ctrl+Z) in one workbook reverts changes made in a completely different open workbook, because the undo stack is shared globally across the application.
Save all your currently open workbooks to prevent data loss before attempting to open files in separate Excel instances.
Open Workbooks in Separate Excel Instances
Opening your workbooks in completely separate application instances of Excel forces each window to maintain its own independent undo and redo history.
By default, Excel opens all workbooks within the same application process (instance) to save system memory. Because the undo history is tied to the application process rather than the individual file, actions are grouped globally.
You can bypass this by forcing Excel to launch a completely new background process for your second workbook.
Launch Excel and open your first workbook normally.
Right-click the Excel icon on your Windows taskbar. Hold down the 'Alt' key on your keyboard and click the 'Excel' application name in the popup menu. Keep holding 'Alt' until a prompt appears.
When the dialog box asks 'Do you want to start a new instance of Excel?', click 'Yes'.
In this newly opened, independent Excel window, go to File > Open and select your second workbook. The undo histories will now be completely separate.
Submit Feedback and Rely on AutoSave
Since the shared undo stack is a hardcoded architectural design in desktop Excel, adopting safer saving habits is the official long-term workaround.
Try WPS Office for a Seamless Spreadsheet Experience
If Excel's shared undo history disrupts your workflow, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative to Microsoft Office that provides a clean, tabbed interface for managing multiple spreadsheets effortlessly.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer. Once completed, open WPS Spreadsheets.
- 3. Open Your Files: Open your existing Excel workbooks in WPS Spreadsheets and enjoy a smoother editing experience.
Frequently Asked Questions
Can I disable the shared undo history in Excel settings?
No, the shared undo history is a core architectural component of the desktop version of Microsoft Excel. There is currently no built-in setting or toggle in the Options menu to disable it.
Does Excel Online have the same shared undo issue?
No. If you use Excel for the Web (Excel Online) in your browser, each workbook is opened in a separate browser tab or window, meaning they each maintain their own independent undo and redo histories.
Why does Excel group undo actions globally by default?
By default, Windows opens all workbooks in the same Excel application process (instance) to conserve system memory and resources. Because the undo stack is tied to the application instance rather than the individual file, the actions are grouped together.
