Version History Issues

Fix SharePoint Online Document Versions That Won’t Open in Excel 2016

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

The user needs to open an earlier version of an Excel document stored in SharePoint Online.

Fix SharePoint Online Document Versions That Won’t Open in Excel 2016
Product
SharePoint Online and Microsoft Excel 2016
Device & OS
not provided
Scenario
A previous workbook version is downloaded from SharePoint version history and opened in Excel 2016.
Observed behavior
The download succeeds, but Excel reports that it cannot open the file.
Before you start

Confirm that you can access the workbook’s Version history in SharePoint and note the exact Excel error message. Check whether the issue affects one workbook or multiple files before changing settings.

Solution 1Recommended

Allow encrypted pages to be saved to disk

Use this legacy Internet Options fix when downloaded SharePoint versions cannot be opened in Excel 2016.

1
Open Internet Options

Open Internet Options in Windows, or in Internet Explorer choose Tools > Internet options if Internet Explorer is available.

2
Change the security setting

Select the Advanced tab. Under Security, clear the checkbox for Do not save encrypted pages to disk, then select Apply and OK.

3
Retry the version

Restart Internet Explorer if you used it, then return to SharePoint, open the workbook’s Version history, and try downloading and opening the earlier version again.

Allow encrypted pages to be saved to disk
Security and browser support: This setting allows encrypted web content to be cached on disk. Check your organization’s security policy before changing it. Internet Explorer is retired, so availability and behavior may vary.
Free Microsoft Office alternative

Open Excel Workbooks with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with compatible Excel files. Open a successfully downloaded workbook in WPS Spreadsheet as an alternative, although WPS does not repair SharePoint version history or Excel 2016 settings.

Open compatible downloaded workbook versions in WPS SpreadsheetCompatible with Microsoft Excel formats, including XLS and XLSXFamiliar spreadsheet interface for an easier transition from Microsoft OfficeFree and lightweight office tools for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Why does an older SharePoint version download but fail to open?

Internet Options security settings or the Office document cache can interfere with opening downloaded versions in Excel 2016. Check Internet Options > Advanced > Security and test the download in another browser.

Where can I find an earlier version of a workbook?

In SharePoint, locate the workbook, open its menu, and select Version history. Choose the earlier version and use the available option to download or open it.

Will resetting Internet Explorer settings change other preferences?

Yes. Internet Options > Advanced > Reset resets Internet Explorer settings, so review the reset options and your organization’s policy before confirming.

What should I check before clearing the Office document cache?

Open Office Upload Center and resolve pending or failed uploads first. Deleting cached files may affect locally cached changes that have not been uploaded.

Can WPS Office fix SharePoint version history?

No. WPS Office can open compatible downloaded Excel workbooks, but it does not fix SharePoint version history or Excel 2016 configuration issues.