Document Editing Problems

How to Fix Undo Problems in a Co-Authored Excel File

Muhammad TalhaMuhammad Talha Oct 10, 2026 870 views

Question details

The user needs to resolve an issue where using the Undo function in a shared workbook causes unexpected modifications or blank sections to appear.

How to Fix Undo Problems in a Co-Authored Excel File
Product
Microsoft Excel
Device & OS
not provided
Scenario
Editing or co-authoring a shared Excel workbook with other users while AutoSave is active.
Observed behavior
Pressing Undo results in unintended changes, synchronization errors, or blank sections becoming visible to other editors in the workbook.
Before you start

Before attempting any fixes, immediately save a separate offline copy of the affected workbook to prevent permanent data loss or accidental overwrites during the co-authoring session.

Solution 1Recommended

Open a Support Request via Microsoft 365 Admin Center

Since this specific co-authoring undo behavior often points to a software defect or a backend synchronization error, escalating the issue to Microsoft Support is the most effective approach.

In complex shared environments, undo commands can sometimes conflict with AutoSave and version history, requiring Microsoft's technical team to investigate the backend revision logs.

1
Contact your administrator

Reach out to your organization's Microsoft 365 administrator, as standard users typically do not have the permissions required to open an official service request.

2
Navigate to the support section

Have the administrator log into the Microsoft 365 admin center, navigate to the 'Support' tab on the left-hand menu, and select 'New service request'.

3
Provide detailed evidence

Preserve the affected workbook and its version history. Clearly record and submit the exact steps that reproduce the undo problem to help the support team investigate.

Open a Support Request via Microsoft 365 Admin Center
Important: Temporarily use a recovered version or an offline, non-shared copy for your business-critical work while waiting for the support team's resolution.
Free Microsoft Office alternative

Switch to WPS Office for Reliable Spreadsheet Management

If persistent synchronization bugs and undo errors in Microsoft Excel are disrupting your team's workflow, consider switching to WPS Office. It provides a lightweight, highly stable environment for managing complex spreadsheets and avoiding unpredictable shared-editing conflicts.

  1. 1. Download and install WPS Office: Get the free WPS Office suite from the official website and follow the installation wizard.
  2. 2. Open your spreadsheet: Launch WPS Spreadsheets, click 'Open', and select your existing .xlsx files to continue working seamlessly.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv), ensuring seamless file sharing.Stable offline and cloud editing capabilities that prevent unexpected synchronization errors.Familiar tabbed user interface, allowing your team to switch with zero learning curve.Lightweight architecture that runs smoothly even on older devices without lagging.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Undo function behave unpredictably in shared Excel files?

When multiple users edit a document simultaneously with AutoSave turned on, the local undo stack can become confused by overlapping changes from different authors. This can occasionally lead to synchronization errors, data overlaps, or blank cells appearing when a change is reverted.

Can I disable co-authoring to prevent this undo issue?

Yes. You can prevent live co-authoring conflicts by checking out the file in SharePoint, or by saving the workbook to a local drive instead of OneDrive or SharePoint. This forces the file to be edited by one person at a time.

Will clearing the Excel cache fix co-authoring glitches?

It can help. Clearing the Office Document Cache via the Office Upload Center or Office application settings forces Excel to re-sync the file directly from the server, which may resolve localized display issues like the sudden appearance of blank sections.

How do I recover data lost due to the co-authoring undo bug?

The most reliable method is to use Excel's built-in Version History feature. You can access this via File > Info > Version History to find and restore a snapshot of the file taken immediately before the problematic undo action was executed.