Thursday 4 August 2016

Cannot open Excel file exported via Salesforce Report export after Microsoft Office update on July 12th 2016


I believe that most of you are familiar with Salesforce Report Export feature. So, today I am not planning to explain how to export xls from Salesforce standard report, but I would like to share what I have encountered on this well-known feature.

After I downloaded the file, I couldn't open it via MS excel 2013. Thus, I tried to view it via notepad, I found that the table style is ready in the connect. However, I couldn't open it via excel. That's why I tried to search this issue in "Salesforce Success Community". And I am confused as I have found this issue on it.



https://success.salesforce.com/issues_view?id=a1p3A000000IZSEQA4

My current issue
1. Create a report and export it as "Printable View" or "Export Details"
2. Open the report by Excel on Windows.
3. Excel will show empty content.

Summary
Following the installation of a Microsoft security update released on July 12, 2016, users are unable to open Excel files downloaded from several websites, including Salesforce.
The update is documented in the Microsoft article linked below:
https://support.microsoft.com/en-us/kb/3170008 

UPDATE ***** 7/22/2016*****
Microsoft has published a KB Article about this issue, including suggested workarounds:
https://support.microsoft.com/en-us/kb/3181507

Repro
After applying the MS Office update from Microsoft:
Microsoft Security Bulletin MS16-088 - Critical
Security Update for Microsoft Office (3170008)
Published: July 12, 2016
https://technet.microsoft.com/library/security/MS16-088 

1. Create a report and export it as "Printable View" or "Export Details"
2. Open the report by Excel on Windows.
3. Excel will show empty content.

Workaround
Note: Salesforce cannot advise on the settings or applied patches for Microsoft products. Please work with your internal IT department to determine the best course of action for users within your organization.

We are working in cooperation with Microsoft to resolve this issue.
​WE HAVE IDENTIFIED FOUR WORKAROUNDS AS OPTIONS FOR OPENING EXPORTED REPORTS UNTIL THIS ISSUE IS FULLY RESOLVED:

1. Unblock access in File Properties. To do this:
-Right click on the file and choose Properties
-On the General tab, click Unblock
-Click OK


OR

2. Disable the Protected View setting within Excel. To do this:
-Open MS Excel
-Go to File > Options
-Click Trust Center (from the menu on the left)
-Click the 'Trust Center Settings' button
-Click Protected View (from the menu on the left)
-Remove the check mark next to "Enable Protected View for files originating from the internet"
-Click OK
-Click OK



OR

3. Change the export file format to "Comma Delimited .csv". To do this:
-Run the report and then click Export Details
-Change the export file format to "Comma Delimited .csv"
-Click Export
NOTE: Exported .csv files do not contain the formatting found in the .xls files. Please review the exported file to ensure it meets your needs.

4. Remove this specific MS update from the local computer


At the end, I have chosen Option 1. And it works!










No comments:

Post a Comment

Back to Top

What I Can Help

SALESFORCE CUSTOM SOLUTION DESIGN

SALESFORCE STRATEGY AND PLANNING

Do you wanna share posts

I am always looking for writers that have something interesting to say about Salesforce. Whether you have a post in mind or would like to collaborate on one, get in touch! - Click Contact Me