Version History Issues

How to Restore a Previous Excel Version Opened as Read-Only

Algirdas Jasaitis Oct 19, 2026 869 views

Question details

The user is unable to restore a previous version of an Excel workbook because it opens in read-only mode or Protected View.

How to Restore a Previous Excel Version Opened as Read-Only

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to revert to an older version of a workbook using the Version History pane.
Observed behavior: The selected previous version opens as a read-only file, preventing the user from using the Restore command or saving changes directly.

Before you start

Make sure you are logged into your Microsoft 365 account and have the necessary edit permissions for the folder where the original file is stored.

Solution 1Recommended

Enable Editing from Protected View

Bypass Microsoft 365 security blocks by manually enabling editing for a trusted previous version.

Often, files opened from Version History are flagged by Microsoft's security settings and placed into Protected View. Once you confirm the file is from a trusted source, switching to Edit mode will re-enable the Restore command.

Locate the security warning

Look for the yellow message bar at the top of the Excel window indicating that the file is in Protected View or read-only mode.

Enable editing

Click the 'Enable Editing' button within the yellow bar. If prompted by a dialog box asking if you want to continue editing, click 'Yes'.

Restore the version

Once the file switches to Edit mode, navigate back to the Version History pane and click the 'Restore' button.

Check Permissions: Ensure the original workbook is closed before attempting to restore the older version, as an open workbook may lock the file.

Solution 2

Save a Copy of the Previous Version

Save the read-only version as a new file to bypass restrictions and replace the original workbook.

Solution 3

Add a Trusted Location in Trust Center

Prevent Excel from blocking files by adding the document's folder to your Office Trusted Locations.

Free Microsoft Office alternative

Try WPS Office for Seamless File Management

Experience hassle-free document version control and robust spreadsheet editing without complex security blocks. WPS Office is a lightweight, free alternative that offers a familiar interface and seamless migration from Microsoft Excel.

1. Download WPS Office: Visit the official WPS website and download the free installation package for your device.
2. Open your Excel file: Launch WPS Spreadsheet, click on Menu > Open, and select your existing .xlsx workbook.
3. Edit without restrictions: Enjoy smooth editing, auto-saving, and straightforward backup management without unexpected read-only locks.

Free and lightweight Office suite with low system requirementsFully compatible with Microsoft Excel (.xlsx) files and formulasIntuitive and easy-to-use version history managementFamiliar user interface requiring no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my previous Excel version open in Protected View?

Microsoft Excel opens files from the internet or certain synchronized locations (like OneDrive or SharePoint) in Protected View to prevent potentially malicious scripts from running automatically. It forces the file into a read-only state until you verify it is safe.

Can I permanently disable Protected View for version history?

While you can disable Protected View by going to File > Options > Trust Center > Trust Center Settings > Protected View and unchecking the options, it is highly discouraged as it leaves your computer vulnerable to unsafe downloads. It is better to use Trusted Locations instead.

What if the 'Enable Editing' button is missing?

If the button is missing, the file may be blocked at the system level. You can right-click the file in Windows File Explorer, select Properties, check the 'Unblock' box at the bottom of the General tab, and click Apply.

Does Excel keep version history for local files?

No, Excel's built-in Version History pane requires the workbook to be saved in OneDrive or SharePoint. If the file is saved locally on your hard drive, you will need to rely on Windows File History or manually saved backups.

Document & File Issues