To open 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 in the pane to open it. Version history lets you review earlier saved copies and, if needed, restore one without rebuilding the workbook from scratch. It is not available for a workbook saved only on your computer.
What You’ll Need
- A workbook stored in OneDrive or SharePoint. Excel’s built-in version history depends on the workbook being saved to a cloud location that keeps versions. A local file, such as one in Downloads or on your desktop, does not automatically have this history.
- Access to the account or organization where the workbook is stored. Sign in to Microsoft 365 with the account that can open the file. For a work or school SharePoint library, your organization’s settings may affect whether versions are retained.
- Excel for Microsoft 365 on Windows for the main steps below. Excel for the web and Excel for Mac have similar options, but their menu paths differ slightly; those paths are included in the steps.
Step-by-Step
- Open the cloud-stored workbook. In Excel, use File > Open to find the file under OneDrive or SharePoint, or open it from its location in OneDrive or SharePoint. Check that you have the intended workbook, especially if there are similarly named copies. If a sign-in prompt appears, sign in to the account that has access to the file.
- Check that you are working with the cloud copy. Look at the file name and location in Excel. If the workbook is open from a local folder or an email attachment, its cloud version history may not be available. If you need history for it, save or upload it to OneDrive or an appropriately configured SharePoint library first. Confirm that you are not creating a separate copy when saving.
- Open the File tab. In Excel for Microsoft 365 on Windows, select File at the upper left of the ribbon. This opens the Backstage view, rather than a worksheet tab. Select Info in the left-hand menu. The workbook details and available file actions appear on this page.
- Select Version History. On the Info page, choose Version History. Excel opens a version history pane, usually along the right side of the window. If you do not see the command, make sure the workbook is saved in OneDrive or SharePoint and that you are signed in. Continue to Troubleshooting if the option is still missing.
- Choose a version to inspect. Review the dates and times listed in the pane, then select the entry you want to check. Excel opens that saved version separately, typically in read-only mode, so you can review its contents without immediately replacing the current workbook. Look at the version’s date and the workbook itself before taking any action.
- Compare the earlier copy with the current workbook. Check the relevant sheets, cells, formulas, and formatting. Version history is a list of saved copies, not a cell-by-cell comparison report, so you may need to switch between the earlier version and the current workbook to identify what changed. Do not assume that the newest entry represents a particular edit unless its time and contents confirm it.
- Restore only if you want that earlier version to become current. If you decide to roll the workbook back, use the Restore command shown for the selected version. Read any confirmation message and verify that you have the right version before confirming. Restoring changes the current workbook to the selected earlier state; it is different from merely opening that version to inspect it.
- Keep a copy if you may need the current state. Before restoring, consider using File > Save As to save a separate copy of the current workbook, if your access and organization’s policies allow it. After restoration, check the workbook and confirm that the expected sheets and data are present. Version history should continue to show saved versions according to the storage service’s settings.
Other Excel versions: In Excel for the web, open the workbook and choose File > Version History, then select a listed version to view it. In Excel for Mac, open the workbook and use File > Browse Version History; the precise wording or location can vary with the Microsoft 365 build. In each case, the file must be stored in OneDrive or SharePoint, and restoring is a separate action from viewing.
Common Mistakes
- Looking for history on a local-only file. Excel does not create cloud version history just because a file is an .xlsx workbook. If it is saved only on your computer, check whether you have a backup or another copy. For future history, save the working file to OneDrive or SharePoint and use that same cloud copy.
- Opening an email attachment or downloaded copy. These files may have the same name as the original but are separate copies. Opening the attachment does not necessarily connect it to the original file’s version list. Open the workbook from its OneDrive or SharePoint location instead.
- Confusing opening with restoring. Selecting a dated entry is a way to inspect an earlier saved version. Choosing Restore makes that earlier state the current workbook. Read the prompt and verify the selected date before confirming a rollback.
- Assuming every keystroke is recorded as its own version. Version history records saved versions, not a continuous replay of every edit. It may not show an unsaved change or identify who changed each individual cell. Check the version timestamps and save status when interpreting the list.
- Restoring without protecting newer work. A rollback may remove later edits from the current view of the workbook. Save a separate copy first if you might need those edits, and follow any workplace rules for keeping or sharing copies.
Tips
- Use AutoSave with the cloud file. When AutoSave is available and turned on, changes to a OneDrive or SharePoint workbook are saved automatically. This can help keep the current copy up to date, but it does not mean every keystroke appears as an individual version. Check the AutoSave switch and the save status before closing the workbook.
- Read dates in context. A timestamp tells you when a version was saved, not necessarily exactly when a particular cell was edited. If several people work in the file, use the time, the content, and any available organizational audit tools together rather than relying on the timestamp alone.
- Use descriptive file names for deliberate checkpoints. If you need a named milestone, save a separate copy with a clear name, such as a dated review copy, in addition to relying on automatic version history. Keep copies in an approved location so other collaborators do not mistake them for the live workbook.
- Keep the file in one shared location. If you switch between a local copy and a cloud copy, edits can split across different files. Share the OneDrive or SharePoint link with collaborators and make sure everyone is working in the intended workbook.
- Check with an administrator for workbooks in a managed library. A SharePoint site or organization may have policies that control whether versioning is enabled, how many versions are kept, or how long they remain available. Ask the site owner or Microsoft 365 administrator if the workbook’s history appears incomplete.
Troubleshooting
Version History is missing or unavailable: First confirm the workbook’s location. In Excel, check whether it is the OneDrive or SharePoint file, rather than a local download or attachment. Then confirm that you are signed in to the correct Microsoft 365 account and have permission to access the file. Close the local copy and reopen the cloud-stored workbook if necessary. If the file is in a work or school SharePoint library, ask its owner or administrator whether versioning is enabled and whether your access permits viewing versions.
The history pane opens but has no useful entries: The file may be new, or older versions may not have been retained. Version history cannot recreate changes from before the workbook was stored in a location that recorded versions. Check whether another copy exists in OneDrive, SharePoint, a backup system, or an approved team folder. Do not assume that saving a local copy into the cloud will bring along its previous editing history.
You cannot open a listed version: Check your internet connection, sign-in status, and access to the original file. Close the history pane and reopen it, or open the workbook again from OneDrive or SharePoint. If you are using Excel for the web, try the workbook in the desktop app, or vice versa. If the problem continues for a work file, contact the site owner or administrator; a permission or service issue may prevent access.
You restored the wrong version: Reopen Version History and look for the version that contains the state you need. Before restoring again, save a separate copy of the current workbook if you need to preserve its contents. Then select the correct dated version and confirm the restore prompt. If the needed version is no longer listed, contact your organization’s administrator promptly to ask whether a retained backup is available.
The restored workbook does not look as expected: Check the version date, the active workbook name, and whether you have reopened the cloud file rather than a similarly named local copy. Refresh or close and reopen the file so you are not looking at an older window. Check multiple sheets, not just the active one. If important content is absent, inspect the other listed versions before making further changes.
Frequently Asked Questions
Can I open version history for an Excel file saved on my computer?
No, not through Excel’s OneDrive or SharePoint version history. That feature applies to a workbook stored in one of those cloud locations. For a local file, look for a separate backup or prior copy, or save the workbook to a cloud location for version history going forward.
Does opening an earlier version change my current workbook?
Opening a version to inspect it does not itself restore it. The earlier version typically opens separately and read-only. The Restore command is the action that makes the selected earlier state current, so take care to distinguish the two.
Can I recover changes I forgot to save?
Version history contains saved versions, so it may not include edits that were never saved. If Excel closed unexpectedly, check for an available Document Recovery pane or AutoRecover copy, and check the workbook’s version history as well. Recovery options depend on how Excel and the file were configured.
How many versions does Excel keep?
There is no single number that applies to every workbook. Retention can depend on OneDrive or SharePoint settings, the library configuration, and organization policies. If an older version is missing, ask the site owner or administrator about retention rules and backups.
Can I see exactly which cells changed between versions?
Version History helps you open saved copies, but it is not a built-in cell-by-cell comparison view. You can inspect the two copies side by side or use an approved comparison tool if your organization provides one. Take care to compare the correct workbook versions.
Can I use version history in Excel for Mac or the web?
Yes, when the workbook is stored in OneDrive or SharePoint and your account has access. In Excel for the web, use File > Version History. In Excel for Mac, look under File > Browse Version History. Menu wording can vary slightly by app version.
Related
- Open a Numbers File in Excel: Step-by-Step Guide
- How to Insert a Thick Line in Word
- How to Open a CSV ZIP File in Excel Without Losing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Adding a Checkbox to Excel: Setup, Linking, and TipsTo add a checkbox in Microsoft 365 Excel for Windows, select the cell or range where you want…
- Remove a Dropdown List in Excel Without Losing DataTo remove a dropdown list in Excel for Microsoft 365 on Windows, select the cell or cells, go…
- Coin Inventory Spreadsheet: Track Your Collection in ExcelA coin inventory spreadsheet is a simple catalog for recording what you own, where it is stored, and…
- Weekly Budget Spreadsheet Template: Build One in ExcelA weekly budget spreadsheet template is a simple table for comparing planned income and expenses with what actually…
- UK Date Format in Google Sheets: Set Dates CorrectlyTo get UK dates in Google Sheets, set the spreadsheet locale to United Kingdom, then format the date…
- How to Add a Dropdown List in Excel for Data EntryTo add a dropdown list in Excel for Microsoft 365 on Windows, put your choices in a worksheet…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.