Why Word or Excel Undo History Disappears After Running a Macro
Question details
The user wants to understand why Microsoft Word or Excel undo/redo history disappears, especially after running VBA macros, and how to confirm whether it is expected behavior or an Office version, add-in, or system issue.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- User is editing documents or workbooks with VBA macros enabled and notices that the undo/redo history is cleared after running a macro or disappears unexpectedly.
- Observed behavior
- In Excel, the undo stack clears after a macro runs as expected behavior. In Word, undo history disappearing is not normally expected and may indicate an add-in, Office version, or system change.
Before troubleshooting, note your current Microsoft Office version and recent add-ins, updates, or system changes. Save a copy of any open document or workbook so you can test undo behavior in a new file without losing current edits.
Confirm That Excel Clears Undo After a Macro and Word Does Not
Use this first to separate expected Excel macro behavior from an unexpected Word issue.
In Excel, running a macro clears the Undo/Redo stack by design. Word normally preserves Undo history after macros, so if the problem only occurs in Excel, it is not a bug.
Open Microsoft Excel, create a new blank workbook, type a value in a cell, and press Ctrl+Z to confirm Undo works before running any macro.
Press Alt+F8 to open the Macro dialog, select an existing macro, click Run, then press Ctrl+Z. Excel will clear the undo stack after the macro runs.
Open Microsoft Word, create a new blank document, type text, run a macro from the Developer tab or Alt+F8, then press Ctrl+Z. If Word loses Undo history, continue to the next solution.

Update Office and Test with Macros and Add-ins Disabled
Use this when Word loses Undo history, or when you need to rule out an Office version, add-in, or recent system change.
Work Without Macro Undo Disruptions in WPS Office
If Microsoft Word or Excel macro behavior repeatedly disrupts your Undo history, WPS Office provides a free, lightweight alternative with familiar word processor and spreadsheet tools, strong .docx and .xlsx compatibility, and a straightforward interface that makes switching easy.

Frequently Asked Questions
Why does Excel clear the Undo stack when I run a macro?
This is expected behavior in Excel. Any VBA macro changes the workbook through code, so Excel discards the undo history to keep the macro's actions from being reversed incorrectly. Use a backup copy if you need to test a macro safely.
Should Word also clear Undo history after a macro?
No. Word normally keeps undo history after a macro runs. If it disappears in Word, an add-in, Office update, or a specific document setting is more likely to be causing it.
How do I check whether an add-in is causing Word to lose Undo history?
Start Word in Safe Mode by holding Ctrl while launching it, or click File > Options > Add-ins > COM Add-ins > Go and disable add-ins one by one. Then test Undo in a new document.
Will updating Office fix the Undo history problem?
It can help if the behavior is caused by a known bug or outdated build. Open File > Account > Update Options > Update Now, restart Office, and test in a new document or workbook.
What information should I include when reporting this issue?
Include your Office version and update channel, whether the problem occurs in Word, Excel or both, whether macros or add-ins were enabled, and any recent system or Office changes before the issue started.




