Document Editing Problems

Fix Undo Not Working Between Excel for Web and Desktop

Emma BrownEmma Brown Oct 28, 2026 869 views

Question details

The user is unable to undo changes in Excel for the Web that were previously made and saved in the Excel desktop application, particularly affecting formulas.

Fix Undo Not Working Between Excel for Web and Desktop
Product
Microsoft Excel
Device & OS
not provided
Scenario
Editing the same workbook simultaneously or sequentially in Excel for the Web and the Excel desktop app.
Observed behavior
The Undo function in Excel for the Web does not revert formulas or modifications made in the desktop application because the two platforms do not share the same undo history.
Before you start

Before attempting to undo complex changes, ensure that you know exactly which version of Excel (Web or Desktop) was used to make the specific edits you wish to revert.

Solution 1Recommended

Undo Changes in the Specific Application Where They Were Made

Use the local undo history of the application to revert changes made within that specific environment.

Excel for the Web and Excel desktop maintain completely separate undo histories. Changes made in one version cannot be undone from the other version. If you are switching between the two platforms, you must manage edits and reversions locally within each app.

1
Identify the editing environment

Determine whether the change you want to undo was made in Excel for the Web or the Excel desktop application.

2
Switch to the correct application

Open the workbook in the exact application (Web or Desktop) where the edit was originally performed.

3
Perform the undo action

Click the Undo button in the Quick Access Toolbar or press Ctrl+Z on your keyboard to revert the change.

4
Reverse chronological undo for simultaneous edits

If you made alternating edits (e.g., Desktop, Desktop, Web), undo the Web change first in Excel for the Web, then switch to the Desktop app to undo the remaining Desktop changes.

Undo Changes in the Specific Application Where They Were Made
Unsupported Features Limitation: Formulas or features available only in the web version may not translate correctly to the desktop app. Always save a backup copy before testing unsupported formulas.
Free Microsoft Office alternative

Avoid Sync Conflicts with WPS Office

Since Microsoft Excel separates undo histories between its web and desktop versions, managing simultaneous edits can be frustrating. Try WPS Office as a lightweight, highly compatible alternative that offers seamless document management and a unified editing experience without the sync confusion.

  1. 1. Download WPS Office: Get the free WPS Office suite from the official website and install it on your computer.
  2. 2. Open your Excel file: Launch WPS Spreadsheets and open your existing .xlsx workbook.
  3. 3. Edit seamlessly: Make your changes and enjoy a reliable, unified undo history locally.
Fully compatible with Microsoft Excel (.xlsx) formats and complex formulas.Unified editing experience without disjointed undo histories.Free, lightweight, and fast alternative to Microsoft Office.Familiar user interface ensuring seamless migration.
QA img-9

Frequently Asked Questions

Can I view the undo history from the Excel desktop app in Excel for the Web?

No, Excel for the Web and the Excel desktop application maintain separate and independent undo histories. You can only view and undo changes in the specific application where they were originally made.

What happens if I edit a workbook in both Excel Web and Desktop at the same time?

If you edit the workbook simultaneously, each application will only track the edits made within its own interface. To undo changes, you must switch between the web and desktop apps to undo their respective edits in reverse chronological order.

Why did my formula disappear when switching from Excel Desktop to Excel Web?

Some newer formulas or Name Manager entries may only be fully supported in Excel for the Web. Modifying and saving the file in the desktop app might alter or drop these unsupported features, and the web's undo function cannot restore them once the file is saved.