Version History Issues

Fix Excel Unexpectedly Deleting Cells and Undo Not Working

Maira Mehtab Sep 28, 2026 868 views

Question details

The user is experiencing an issue where Excel unexpectedly removes cell data, and the standard Undo command does not work to reverse the changes, requiring a file rollback.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Editing a workbook when cell data unexpectedly disappears and cannot be recovered using normal editing shortcuts.
Observed behavior: Cells are deleted without a user prompt, and the Undo function (Ctrl+Z) fails to restore the data, forcing the user to restore an older file version.

Before you start

Before attempting any fixes, save a copy of your current workbook to a local drive under a new name to prevent further unintended data loss during troubleshooting.

Solution 1Recommended

Restore Previous Data Using Version History

If your file is hosted on OneDrive or SharePoint, you can recover the unexpectedly deleted cells by rolling back to a previous version of the workbook.

Cloud-stored workbooks automatically save iterative versions of your file. Restoring an older version bypasses the broken Undo stack.

Access Version History

Click on the file name at the top center of the Excel window and select 'Version History' from the dropdown menu, or go to File > Info > Version History.

Select an Older Version

Browse the list of previous file states in the right-hand Version History pane. Click 'Open version' on the one saved right before the data loss occurred.

Restore the Workbook

Click the 'Restore' button in the yellow notification bar at the top of the recovered document to overwrite the broken current version.

Temporarily Disable AutoSave

Toggle off the 'AutoSave' switch in the top left corner of the Excel window to prevent background synchronization from causing further immediate conflicts.

Solution 2

Launch Excel in Safe Mode to Check Add-ins

Faulty add-ins or background VBA macros can execute actions that delete cells and simultaneously clear your undo history.

Solution 3

Run an Office Quick Repair

A corrupted Office installation can cause unexpected behavior like random cell deletions. Running a Quick Repair resolves underlying software glitches.

Free Microsoft Office alternative

Switch to WPS Office for Reliable Spreadsheet Management

If Microsoft Excel continues to unexpectedly delete cells or suffers from broken Undo functionality, consider switching to WPS Office. It provides a highly stable, lightweight alternative for managing your spreadsheets without frustrating data loss.

1. Download and Install: Download WPS Office for free from the official website and install it on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and click 'Open' to select your existing .xlsx workbook.
3. Edit Safely: Continue editing your data with full formatting preservation and a reliable, working undo function.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Lightweight architecture ensures fast performance without unexpected software crashes.Built-in robust local backup and document recovery features protect against data loss.Familiar user interface guarantees a seamless and immediate transition from MS Office.

Frequently Asked Questions

Why does the Undo function (Ctrl+Z) suddenly stop working in Excel?

The Undo history in Excel is automatically cleared whenever a VBA macro runs. If a background macro executes, you instantly lose the ability to undo your previous actions.

How can I tell if my Excel file itself is corrupted?

You can test for file corruption by copying your data into a brand-new blank workbook. If the random cell deletion stops in the new file, your original workbook is likely corrupted.

Does AutoSave cause Excel to overwrite my data?

While AutoSave itself doesn't delete data, synchronization conflicts with OneDrive or SharePoint can sometimes revert changes or overwrite recent edits, which looks identical to data loss.

Can I recover deleted Excel cells if I haven't saved my file?

If the Undo button is broken and you have not saved, you must rely on Excel's AutoRecover feature (File > Info > Manage Workbook > Recover Unsaved Workbooks) or cloud Version History if the file is synced to OneDrive.

Document & File Issues