Cannot open Excel file exported via Report export after Microsoft Office update on July 12th 2016
|Knowledge Article Number||000240427|
On July 12th, 2016, Microsoft released a security update for Office which caused files downloaded from several websites (including Salesforce) to generate errors when opened.
Impact to Salesforce files
Salesforce files downloaded via "Printable View" and "Export Details" generate a "file is corrupt and cannot be opened" error when opened.
Fix "Export Details" file access errors
To open files created via Export Details, install Microsoft's latest Office update (download Microsoft's software patch here). If you're unable to install the patch, try one of the workarounds listed later in this article.
Fix "Printable View" file access errors
Workarounds for "Export Details" if you're unable to install Microsoft's latest Office software patch
We have identified four workarounds as options for opening exported reports in Excel until you are able to install the Microsoft patch linked above.
Change the export file format to "Comma Delimited .csv"
Note: Exported .csv files do not contain the formatting found in .xls files. Please review your exported file to ensure it meets your needs.
1. Run your report.
Unblock access in File Properties
1. Right click on the file, select Properties.
Disable the Protected View setting within Excel
1. Open Microsoft Excel.
Remove this specific Microsoft update from the local computer
If none of these workarounds work for you, you can uninstall the original patch which caused the issue as a last resort. If you have questions about how to remove the patch, please consult Microsoft's support.