Fix SharePoint Online Document Versions That Won’t Open in Excel 2016
Question details
The user needs to open an earlier version of an Excel document stored in SharePoint Online.

- 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.
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.
Allow encrypted pages to be saved to disk
Use this legacy Internet Options fix when downloaded SharePoint versions cannot be opened in Excel 2016.
Open Internet Options in Windows, or in Internet Explorer choose Tools > Internet options if Internet Explorer is available.
Select the Advanced tab. Under Security, clear the checkbox for Do not save encrypted pages to disk, then select Apply and OK.
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.

Reset Internet Options and clear the Office document cache
Try these additional steps if the security setting does not resolve the error.
Test the download in another browser
Use a browser comparison to help determine whether the problem is specific to the download process or a particular workbook.
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.

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.




