How to Find Version History in Excel and Restore a Copy

To find version history in Excel for Microsoft 365 on Windows, open the workbook saved in OneDrive or SharePoint, then select File > Info > Version History. Choose a dated version to open and inspect it; use Restore only if you want that version to become the current workbook. Version history is available for cloud-stored files, not ordinary local files, so save or move the workbook to OneDrive or SharePoint first if needed.

Version history lets you review earlier saved states of a workbook and, when appropriate, return to one. It can help recover from unwanted edits, deletions, or formatting changes, but it is not the same as a cell-by-cell edit log. The exact versions available depend on where the file is stored, your access, and how often changes have been saved.

What You’ll Need

A Microsoft 365 Excel workbook stored in OneDrive or a SharePoint document library. A local file, email attachment, or file on an ordinary network drive may not have cloud version history.
Permission to open the workbook. To restore or manage versions, you may need editing permission; people with read-only access might only be able to view versions or may not see the feature.
An internet connection and the account used to access the file. If it is a work or school SharePoint file, sign in with the organization account that has access.
For a cautious recovery, a place to save a separate copy of the current workbook before restoring an older version.

Step-by-Step

Open the right workbook. In Excel, open the file from OneDrive or SharePoint, or browse to the cloud location and open it from there. Check the workbook name and location before proceeding, especially if you have similarly named local and cloud copies. A workbook opened from Downloads or a computer folder is generally not the same file as its cloud counterpart, even if the names match.
Confirm that the file is saved to the cloud. In Excel for Windows, look near the workbook name or use File > Info to check its location and status. AutoSave is commonly available for eligible OneDrive or SharePoint files; it is not proof by itself that you have opened the intended copy. If the workbook is local, use File > Save As and save it to OneDrive or a SharePoint location. The file will then accumulate versions as changes are saved; moving it does not necessarily bring along a history from an unrelated copy.
Open the Version History pane. Select File > Info > Version History. Excel opens a pane listing available saved versions, usually with dates and times. If you do not see Version History, confirm the file is cloud-stored and that you are signed in. The command may be unavailable for a local workbook, a file type or account that does not support the feature, or a file you cannot access properly.
Find a useful point in time. Read the timestamps and, where shown, the names of people who saved changes. Start with a version from just before the unwanted change. Remember that a timestamp identifies a saved state, not necessarily the exact moment a particular cell was edited. If several collaborators were working, the version may include multiple people’s changes up to that save.
Open a version before changing anything. Select the version you want to inspect. Depending on the Excel build and file, Excel may open it in a separate window or show an option to open it. Check the title bar and look for an indication that you are viewing an earlier version. Inspect relevant worksheets, formulas, named ranges, tables, charts, and formatting. Do not assume that the preview alone shows every part of a complex workbook.
Choose whether to restore or copy information. If you want the entire workbook to return to that earlier state, select Restore in the version history interface and confirm if prompted. This makes the chosen version current; it does not simply undo one cell edit. If you only need a few values or formulas, copy them from the opened older version into the current workbook instead. For a safer full-file recovery, use Save As to create a separate copy of the older version if that option is available, then compare it with the current file.
Check the result in the current workbook. After restoring, return to the main workbook and verify the affected sheets and calculations. Look for changes made after the selected version that you still need, including other people’s work. Restoring an older state can remove those later changes from the current file, so do not treat it as a targeted undo. If the result is wrong, reopen Version History and select a more suitable version, or use the saved copy to recover the needed content.
Save and communicate the change. Cloud workbooks usually save automatically when AutoSave is on, but check the save status before closing. If other people use the workbook, tell them which version was restored and ask them to check their current copy. For important shared files, consider retaining a clearly named recovery copy in an approved folder rather than leaving multiple ambiguous files with names such as Final or Final2.

Excel for the web: Open the workbook in a browser and look for Version history from the workbook name or the File menu; the available label and placement can vary with the interface. Select a version to review it, then use the restore option only when you intend to replace the current state. If the command is missing, open the file in the desktop app and check File > Info > Version History, or ask the file owner about access.

Excel for Mac: For a cloud workbook, use File > Browse Version History if that command appears in your Excel version. Some Mac builds provide version history from the workbook name in the title bar. The wording and location can differ from Windows, and the feature depends on the file being in OneDrive or SharePoint. Excel for the web is another option when the Mac desktop interface does not show the command.

Common Mistakes

Looking at a local copy. A workbook saved only on the computer will not show OneDrive or SharePoint version history. Confirm the location of the file you actually opened rather than relying on its filename.
Restoring when you only need one item. Restore affects the workbook as a whole. If you need a prior formula or a few rows, open the older version and copy only what is necessary, checking references and formatting after pasting.
Choosing a version by date alone. A version from the right day may still be too early or too late. Inspect its contents before restoring, and consider the work other collaborators may have done since then.
Confusing version history with Track Changes. Version history provides earlier file states; it does not automatically identify every edit, show a complete cell-level audit, or explain why someone changed a value.
Assuming an email attachment shares the cloud file’s history. A downloaded or attached copy is often a separate file. Open the original OneDrive or SharePoint workbook to see its history.

Tips

Before a major recovery, save a separate copy of the current workbook in a location allowed by your organization. This gives you a reference if you need to retrieve recent work after restoring.
Use timestamps alongside workbook content. A file may have several versions close together, so open likely candidates and check the specific sheet, cell area, or chart involved.
When several people edit a workbook, coordinate before restoring. Ask collaborators whether they have unsaved changes or later work that must be preserved.
Keep the workbook in its original OneDrive or SharePoint location when possible. Moving, downloading, or uploading copies can make it harder to tell which file has the relevant history.
For a small correction, consider using Undo while the workbook is still open and the unwanted action is recent. Version history is more useful when the change was saved earlier or the file was closed, but it restores a broader state.
If you regularly need a record of who changed specific data and when, use an approved auditing process suited to your organization. Version history is useful for recovery, but it may not meet formal recordkeeping requirements.

Troubleshooting

Version History is missing or disabled: First check whether the workbook is saved in OneDrive or SharePoint and whether you are signed in to the account that owns or can access it. In Excel for Windows, try File > Info. If the workbook is local, save it to a supported cloud location. If it belongs to an organization, an administrator’s policies or your permissions may affect access; ask the owner or Microsoft 365 administrator to check.

The version list is empty or has only a few entries: Version history does not create earlier cloud versions for a file that was never stored there. It also cannot show changes that were never saved. If the file was recently uploaded, its history may begin only from that point. Check whether you opened the correct copy and whether another account or SharePoint library contains the original.

You cannot restore a version: You may have view-only permission, or the workbook may be open in a context that does not allow restoring. Try opening it in Excel for the web or the desktop app while signed in with the correct account. If Restore remains unavailable, ask the owner for editing access or ask them to restore the version. Avoid downloading and overwriting the file unless you understand how that affects shared copies.

The restored workbook is missing recent work: A restore returns the workbook to the selected saved state, so later changes may no longer be in the current file. Open Version History again and inspect newer versions. Copy needed material from a later version into the restored workbook, or use a separate copy to compare the two. Take care with formulas that refer to other sheets or ranges.

You need a file that was never saved: Version History only helps with saved versions. For an unsaved or unsynced file, check Excel’s recovery options, including File > Info for available workbook recovery entries, and check OneDrive sync status or the Recycle Bin if the file was deleted. Recovery options depend on the situation and do not guarantee that an unsaved change can be recovered.

Frequently Asked Questions

Can I find version history for an Excel file saved on my computer?
No, not through OneDrive or SharePoint version history. Save the workbook to OneDrive or SharePoint for future cloud versions. For a local file, check any separate backup or Windows file-history system that your computer or organization has configured.

Does restoring a version delete the newer versions?
Restoring makes the selected older state current, but the newer saved state may remain available in the version list. Check the list after restoring, and keep a separate copy if the newer content is important or your organization has specific retention rules.

Can I see exactly which cells changed?
Not reliably from the version list alone. It shows saved workbook states, not a guaranteed cell-by-cell audit. Open two versions and compare the relevant areas, or use a separate change-tracking or audit process if you need detailed attribution.

How far back does Excel version history go?
There is no single duration that applies to every file. The number and age of available versions depend on the storage service, account or organization settings, and retention policies. If an old version is missing, ask the OneDrive or SharePoint administrator whether a retention policy applies.

Can I use version history in Excel for the web or Mac?
Yes, for supported workbooks stored in OneDrive or SharePoint, but the command’s name and location can differ by app version. In the browser, check the workbook name or File menu; on Mac, check File > Browse Version History or the workbook name menu.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.