sodcalculator

10 Tech How-To

Excel Version History: How to Use It

Guide 10-57574 · Updated · Step by step

Version history in Microsoft Excel lets you view, restore, or copy earlier versions of a workbook that you or others have edited. It works automatically for files saved to OneDrive, SharePoint, or Microsoft 365, so you don’t need to manually save snapshots. This guide walks you through accessing the version history, restoring an old version, and avoiding common pitfalls.

What You’ll Need

  • A Microsoft 365, OneDrive, or SharePoint account (free Microsoft accounts work too).
  • Excel for Microsoft 365, Excel on the web, or the Excel mobile app. (Version history is not available in Excel 2019 or earlier standalone versions.)
  • Your workbook must be saved to OneDrive, SharePoint, or another cloud location—not just locally on your computer.

Step-by-Step

  1. Save your workbook to the cloud. If you haven’t already, click File > Save As and choose a cloud location like OneDrive or SharePoint. Once saved there, Excel automatically starts tracking versions.
  2. Open the version history panel. With the workbook open, click File > Info, then click the Version History button. (In Excel on the web, click the File tab, then Version History.) A sidebar will appear listing previous versions with timestamps and author names.
  3. Browse the versions. Click any version in the list to open it in a read-only view. You’ll see the workbook as it was at that time. Use the Previous and Next arrows at the top to move between versions.
  4. Restore a version (if needed). If you want to make an old version the current one, click the Restore button that appears at the top of the version preview. Confirm the restore in the pop-up dialog. Excel will replace the current version with the selected one, and the restored version becomes a new entry in the history.
  5. Copy content from a version without restoring. If you only need a part of an old version, open it, select the cells you want, copy them (Ctrl+C), then close the version view and paste them into your current workbook.
  6. Compare versions side by side (optional). In the version history panel, click the Compare button (if available) to open two versions side by side. Differences are highlighted, making it easy to spot changes.
  7. Manage version settings (optional). For OneDrive files, you can adjust how often versions are kept. Go to the OneDrive website, right-click the file, select Version history, and then choose Version history settings to set a retention period (e.g., 30 days).

Common Mistakes

  • Saving only locally. If you save the file to your desktop or Documents folder, version history won’t work. Always save to OneDrive or SharePoint.
  • Using an older Excel version. Version history is a Microsoft 365 feature. If you’re using Excel 2016 or earlier, you won’t see the Version History button.
  • Confusing version history with AutoRecover. AutoRecover saves temporary copies after a crash, while version history stores every edit session. Don’t rely on AutoRecover for long-term version tracking.
  • Restoring too quickly. Once you restore, the current version is replaced. If you didn’t mean to, you can undo the restore, but it’s safer to copy the data you need first.

Tips

  • Use version history as a safety net. Even if you don’t plan to revert, check it occasionally to see who changed what and when.
  • Name your versions manually. In Excel on the web, you can click File > Version History, then select a version and choose Name this version to give it a memorable label (e.g., “Final draft”).
  • Combine version history with co-authoring. When multiple people edit the same file, version history tracks each person’s changes, making it easier to identify who introduced an error.
  • Use the compare feature for audits. If you need to prove what changed for a review, the side-by-side comparison is invaluable.

Troubleshooting

I don’t see the Version History button. Make sure your file is saved to OneDrive or SharePoint. If it’s still missing, check that you’re signed in with your Microsoft account and that your Excel version supports it (Microsoft 365 or Excel on the web).

Only one version appears. This can happen if the file was recently uploaded or if version history was disabled by your administrator. For OneDrive, check the file’s version history settings on the web; for SharePoint, ask your admin to enable versioning.

I restored the wrong version. You can undo the restore by pressing Ctrl+Z immediately, or go back to version history and restore the version you actually wanted. The restore action itself creates a new version, so the previous state is still there.

Versions are missing for a time period. If the file was edited offline and not synced, those edits may not appear. Also, if you manually saved a copy with a new name, that copy won’t have the same history.

Version history is grayed out. This usually means the file is not in a cloud location. Move it to OneDrive or SharePoint first, then try again.

Frequently Asked Questions

How long does Excel keep version history? By default, OneDrive keeps versions for 30 days, but you can change this to up to 5 years in the version history settings. SharePoint admins set the retention policy.

Can I see version history on Excel for Mac? Yes, Excel for Mac with a Microsoft 365 subscription supports version history via the same File > Info path.

Does version history work for files stored on Google Drive or Dropbox? No, version history only works with OneDrive or SharePoint. For other cloud services, you’d need to use their own versioning features.

Can I download an old version as a separate file? Yes. Open the version, then click File > Save As to save it with a new name. This doesn’t affect the current version.

Will version history slow down my workbook? No, version history is stored in the cloud and doesn’t affect the performance of the file itself. However, very large files with many versions might take a moment to load the history list.

Can I turn off version history? For OneDrive, you can delete all versions or set retention to 0 days, but you can’t disable it entirely. For SharePoint, an admin can disable versioning for a library.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →