Follow

Why can't I open my Datasheet Views in Excel?

UPDATE: 

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:

Office 2010: https://support.microsoft.com/kb/3115476
Office 2013: https://support.microsoft.com/kb/3115455
Office 2016: https://support.microsoft.com/kb/3115438

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

ORIGINAL POST:

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:

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.

Additional Information

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

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request
Please sign in to leave a comment.
Start a 30 Day Free TrialClick ClickNo Credit Card and No Obligation
Powered by Zendesk