Home › Knowledgebase › KB-1652

How To Restore A Previous Version Of A Spreadsheet In Microsoft 365

Summary

This guide helps you troubleshoot and resolve: How To Restore A Previous Version Of A Spreadsheet In Microsoft 365. Follow the steps below to fix the issue.

Quick Tip: Need immediate assistance? đź’» Open a Ticket

Common Causes

Accidentally overwriting a spreadsheet or losing critical data in Microsoft 365 can be stressful, but if your files are stored in OneDrive or SharePoint, you can often recover a previous version quickly. This guide explains how to restore earlier versions of a spreadsheet and how to check for unsynced local edits using the OneDrive sync client. It is written for staff at Australian allied health clinics who manage patient spreadsheets, appointment schedules, and billing records in Microsoft 365.

Before restoring any spreadsheet that contains patient information, confirm you are authorised to modify that record under your clinic’s privacy policies and the Australian Privacy Principles. Restoring a previous version may remove recent clinical entries, so verify that you are not discarding current patient data.

Quick Fix Steps

  1. Open the spreadsheet in Microsoft Excel for the web or the desktop app.
  2. Access Version History from the file menu or title bar.
  3. Select the version you want to restore from the list.
  4. Click Restore to revert the file to that version.
  5. Check OneDrive sync status icons to confirm there are no pending local changes.

Detailed Instructions

Restore A Previous Version Using OneDrive Or SharePoint

  1. Open your web browser and navigate to onedrive.live.com or your organisation’s SharePoint site.
  2. Locate the spreadsheet you need to recover.
  3. Right-click the file and select Version History from the context menu.
  4. In the Version History pane, browse the list of available versions. Each entry shows the date, time, and the name of the person who made the change.
  5. Click on a version to preview it. Verify that the data you need is present.
  6. Click Restore to replace the current version with the selected one.
  7. Alternatively, click Open file to view the older version in Excel without overwriting the current file.
Restoring a previous version creates a new entry in the version history. Your current version is not deleted permanently; it remains available as a previous version.

Restore A Previous Version From The Excel Desktop App

  1. Open the spreadsheet in Excel.
  2. Select File from the top menu, then choose Info.
  3. Click Version History.
  4. Browse the list of versions on the right-hand pane.
  5. Select the version you wish to restore.
  6. Click Restore.

Check For Unsynced Local Edits

If you have been working on a spreadsheet saved to your local OneDrive folder, changes may not have uploaded to the cloud yet. Use the OneDrive sync client status icons to verify.

  1. Locate the OneDrive cloud icon in the Windows taskbar notification area (bottom right of your screen).
  2. Click the icon to open the OneDrive activity centre.
  3. Look for any files showing a blue circular arrow icon. This indicates the file is syncing.
  4. A green tick icon means the file is up to date and synced to the cloud.
  5. A red X icon indicates a sync error. Click View or Repair to resolve the issue.
Do not delete the local copy of a file until you have confirmed it displays a green tick sync status in OneDrive. Unsynchronised changes may be lost if the local file is removed.

Privacy And Clinic Record-Keeping Considerations

Spreadsheets used in allied health clinics may contain patient names, appointment details, treatment notes, or billing information. Under the Australian Privacy Principles, your clinic must take reasonable steps to protect personal information and ensure records are accurate and complete.

Troubleshooting Common Issues

Version History Is Greyed Out Or Not Available

File Is Locked By Another User

Restoring Could Affect Shared Clinic Access

Sync Conflicts Or Duplicate Files

If you cannot recover your spreadsheet using these steps, Open a Ticket for further assistance.

Still Having Issues?

Need more help? If the issue persists after trying these steps, please open a support ticket and our team will assist you.

đź’» Open a Ticket