On the 12th of August Microsoft released a patch to resolve the issue. If you are still experiencing this problem make sure you have applied the following Windows update:
Once the update has installed restart your PC and verify that the problem has been resolved.
Please note the following actions on the workarounds previously mentioned below:
- Workaround 1: This is no longer required as the update resolves this issue.
- Workaround 2: This needs to be reversed
- Workaround 3: This is no longer applicable
Some PPO users have been experiencing a problem where they are unable to open Datasheet Views of reports and dashboards from PPO in Microsoft Excel 2010, 2013 and 2016 on Microsoft Windows.
Affected users have all installed a recent security update for Excel:
- KB3115322 MS16-088: Description of the security update for Excel 2010: July 12, 2016
- KB3115262 MS16-088: Description of the security update for Excel 2013: July 12, 2016
- KB3115272 MS16-088: Description of the security update for Excel 2016: July 12, 2016
Workaround 1: Unblock access to the file:
The following are temporary workarounds we have found to work on Windows. This is to be used until such time the issue is fully resolved.
- After downloading the Datasheet View, open your Downloads folder in File Explorer.
- Right-click on the file and select Properties.
- Ensure the Unblock field is checked (Click the Unblock button on Windows 8).
- Click OK.
- Now open the file in Excel.
NOTE: The workarounds described below may expose you to additional security risks. Check with your IT department.
1.1 Unblock a .xls file if it is contained in a zip file:
When the datasheet view is a large file it gets downloaded as a zipped folder. In most cases you will select open, after downloading the zipped folder, which will open file explorer in the location that the .xls file is located in the zipped folder.
Due to the .xls file being in a zipped folder you would have to unzip the file and then proceed to set the property of the .xls file to be "unblocked" (as per the steps above), as this cannot be set on the .xls file when it is contained in the zipped folder.
Workaround 2: Remove Protected View in Excel:
- Open Excel
- Choose File | Options
- Choose Trust Center
- Click the ‘Trust Center Settings…’ button
- Choose Protected View
- Uncheck ‘Enable Protected View for files originating from the Internet’
- Click OK, OK
Workaround 3: Remove the applicable update from your computer.
Other articles related to the same problem has already surfaced on the internet:
Cannot open Excel file via Report export.
KB3170008 for Office 2016 Breaks Functionality - MS16-088