VBA & Macro Problems

Why Word or Excel Undo History Disappears After Running a Macro

Ayan MasoodAyan Masood Nov 13, 2026 869 views

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.

Why Word or Excel Undo History Disappears After Running a Macro
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 you start

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.

Solution 1Recommended

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.

1
Open a new workbook in Excel

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.

2
Run a macro and test Undo again

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.

3
Repeat the test in Word

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.

Confirm That Excel Clears Undo After a Macro and Word Does Not
Expected Excel behavior: Clearing the Undo stack after a macro runs is normal in Excel and is not something an Office update will change.
Free Microsoft Office alternative

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.

Avoids the Microsoft Excel macro Undo stack clearing behavior that interrupts editing workflowsOpens and saves Microsoft Word .docx and Excel .xlsx files with high format compatibilityFree to download and use for everyday documents, workbooks, and presentationsFamiliar ribbon-style interface reduces the learning curve when migrating from Microsoft Office
microsoft office alternative - wps office

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.