excel file reverted to much older version.

Bill Lane 0 Reputation points
2026-11-15T19:02:00.6733333+00:00

excel file reverted to much older version. shows no version history.

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

2 answers

Sort by: Most helpful
  1. Thomas4-N 23,935 Reputation points Microsoft External Staff Moderator
    2026-11-19T10:07:45.2966667+00:00

    Hello Bill Lane,

    No Version History doesn’t necessarily mean the newer edits are gone. The workbook you opened could be an older copy, and Excel’s Version History doesn’t apply to files saved only on your PC.

    Before restoring anything, I’d check whether Excel opened a different copy of the workbook.

    1. In Excel, go to File > Info and check where the open workbook is saved.
    2. In File Explorer, search for the workbook’s name. If you find more than one copy, compare Date modified, then open the likely match to see whether it contains your newer edits.

    If you don’t find another copy, let us know whether the workbook is saved in OneDrive or only on your PC.

    Was this answer helpful?


  2. AI answer

    2026-11-15T19:02:59.5766667+00:00

    First save a copy of the reverted workbook outside OneDrive, then check its Version History on the OneDrive website because versions may be available there even when none appear in Excel or File Explorer.

    1. Protect the current file

    In Excel, select File > Save a Copy and save it under a different name in a local, non-synced folder or on an external drive. Do not overwrite the current workbook while testing recovered copies.

    2. Check OneDrive on the web

    If the workbook is stored in OneDrive:

    1. Sign in to the OneDrive website with the same account used by Excel.
    2. Locate the workbook.
    3. Right-click it and select Version history.
    4. If an appropriate version appears, use its … menu and select Restore.

    The restored version becomes current, while the previously current version remains in the version list. OneDrive version history is generally retained for 30 days; for work or school accounts, an administrator may have disabled versioning.^1^

    Also check the OneDrive Recycle Bin for another copy that may have been deleted, renamed, or replaced.

    3. Check Excel’s local recovery copies

    If OneDrive web has no usable version:

    1. Open the affected workbook in Excel.
    2. Select File > Info.
    3. Under Manage Workbook, look for a version labeled (when I closed without saving).
    4. Open it and select Restore or, more safely, Save As with a new filename.

    Also check:

    1. File > Info > Manage Workbook > Recover Unsaved Workbooks
    2. Open any promising file.
    3. Immediately select Save As and store it under a new name.

    These options only help if Excel created and retained an AutoRecover copy.^2^

    4. If it was in OneDrive, consider restoring the entire OneDrive

    This is a fallback for a Microsoft 365 subscriber when the workbook was overwritten or corrupted within the last 30 days and file-level recovery is unavailable.

    1. First copy any recently created or changed files that must be preserved to a local non-synced folder or external drive.
    2. On the OneDrive website, open:
      • Personal account: Settings > Options > Restore your OneDrive
      • Work or school account: Settings > Restore OneDrive
    3. Select Custom date and time from before the workbook reverted.
    4. Review the activity feed carefully.
    5. Select Restore.

    Caution: This affects the entire OneDrive, not only the workbook. Files created after the selected restore point are moved to the OneDrive Recycle Bin. The feature requires Microsoft 365 and covers actions within the previous 30 days.^3^

    5. Check Windows backups

    If the workbook was stored locally, or its OneDrive folder was protected by Windows File History:

    1. Open File Explorer and browse to the workbook’s folder.
    2. Right-click the file or containing folder.
    3. Select Restore previous versions.
    4. Select a version dated before the reversion.
    5. Use Restore to… and choose another folder rather than replacing the current file.

    This works only if File History or another Windows backup had already captured that location. Direct restoration replaces the existing file and cannot be undone, so Restore to… is safer.^4^

    If OneDrive web has no version, Excel has no AutoRecover copy, OneDrive Restore has no suitable restore point, and Windows has no previous version or other backup, Microsoft’s listed built-in recovery sources do not contain a newer recoverable copy.


    References

    1. Restore a previous version of a file stored in OneDrive | Microsoft Support
    2. Recover an earlier version of an Office file | Microsoft Support
    3. Restore your OneDrive
    4. Backup and restore with File History | Microsoft Support
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.