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.
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.
Quick Fix Steps
- Open the spreadsheet in Microsoft Excel for the web or the desktop app.
- Access Version History from the file menu or title bar.
- Select the version you want to restore from the list.
- Click Restore to revert the file to that version.
- Check OneDrive sync status icons to confirm there are no pending local changes.
Detailed Instructions
Restore A Previous Version Using OneDrive Or SharePoint
- Open your web browser and navigate to
onedrive.live.comor your organisation’s SharePoint site. - Locate the spreadsheet you need to recover.
- Right-click the file and select Version History from the context menu.
- 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.
- Click on a version to preview it. Verify that the data you need is present.
- Click Restore to replace the current version with the selected one.
- Alternatively, click Open file to view the older version in Excel without overwriting the current file.
Restore A Previous Version From The Excel Desktop App
- Open the spreadsheet in Excel.
- Select File from the top menu, then choose Info.
- Click Version History.
- Browse the list of versions on the right-hand pane.
- Select the version you wish to restore.
- 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.
- Locate the OneDrive cloud icon in the Windows taskbar notification area (bottom right of your screen).
- Click the icon to open the OneDrive activity centre.
- Look for any files showing a blue circular arrow icon. This indicates the file is syncing.
- A green tick icon means the file is up to date and synced to the cloud.
- A red X icon indicates a sync error. Click View or Repair to resolve the issue.
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.
- Confirm you have the appropriate access rights before restoring a file that contains patient data.
- If the spreadsheet is shared with other clinicians or administrators, notify them before restoring a previous version, as this will overwrite the current file for all users.
- Record the restoration in your clinic’s document control log where required by internal policy.
- If you are unsure whether restoring a version could affect patient care or breach privacy obligations, pause and Open a Ticket for guidance.
Troubleshooting Common Issues
Version History Is Greyed Out Or Not Available
- Ensure the file is stored in OneDrive or SharePoint. Files saved only to your local hard drive do not have cloud version history.
- Confirm you have a Microsoft 365 subscription that includes OneDrive or SharePoint.
- Check that you have permission to view version history for the file. If the file is in a shared clinic library, you may need edit rights from the folder owner.
- If the file is opened in protected view or compatibility mode, save it as a modern Excel workbook (
.xlsx) in OneDrive or SharePoint and try again.
File Is Locked By Another User
- If a colleague has the spreadsheet open in Excel, Version History may be unavailable or read-only.
- Ask the other user to close the file, then refresh your browser or restart the desktop app.
- In SharePoint, you can check who has the file open by selecting the file and viewing the details pane.
Restoring Could Affect Shared Clinic Access
- Restoring a previous version replaces the current file for everyone with access to that OneDrive or SharePoint location.
- Use Open file to review an older version first before deciding whether to restore it.
- If the spreadsheet contains current patient appointments or billing entries, create a copy of the current file before restoring, so no data is lost.
Sync Conflicts Or Duplicate Files
- If OneDrive creates a copy with “conflict” in the file name, compare both versions and save the correct data into a single file.
- Ensure you are not opening the same spreadsheet on multiple devices simultaneously, as this increases the risk of sync conflicts.
If you cannot recover your spreadsheet using these steps, Open a Ticket for further assistance.
Still Having Issues?
đź’» Open a Ticket