Interskill Learning Mainframe Training

770-872-4278

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Knowledge Base

Reports Not Exporting to Excel

If you are having trouble exporting the LMS reports to Excel, this is due to a recent Microsoft secuirty update. An explanation of the issue and security changes made by Microsoft can be found here.

 

Symptoms

The Excel team has made a change in the behavior of certain file types to increase security. This change came in the security updates KB3115262, KB3170008, and KB3115322. Previously, when you tried to open an HTML or XLA file with an .XLS file extension from an untrusted location, Excel would warn about the mismatch between the file extension and content, but would still open the workbook without Protected View security. After the security updates Excel no longer will open the workbook because these files are not compatible with Protected View and there is no warning or other indication it was not opened.

 

Workarounds

We have a few options for workarounds. These are in order from safest to riskiest. While some people in the forums have suggested rolling back the security patch, we do not recommend that option as it can leave you open to other current and future threats.

  • You can unblock access for individual files you know are safe. To do this: 
    a. Right click on the file and choose Properties 
    b. On the General tab, click Unblock 
    c. Click OK

  • You can make use of existing Trusted Locations capabilities in Excel 2010, 2013, and 2016 via File -> options -> Trust Center -> Trust Center Settings -> Trusted Locations. 
    a. You can save the web html file to a trusted location on the local machine (Excel comes with a set of default trust locations). If you do not see the local folder location you trust for these files, then press “Add new location…” button and add it in the Trusted Location dialog. If the HTML document is in a trusted location the KB fix is not applied (e.g. the unsafe HTML file is not blocked). 
    b. This approach may unblock you, but it carries some risk as files of any file type in Trusted Locations are fully trusted. If an attacker can drop files into the trusted location they can easily exploit users who open such documents. Be especially cautious when specifying a custom folder as a trusted location.

  • Disable Protected View settings in Excel 2010, 2013, and 2016 via File -> options -> Trust Center -> Trust Center Settings -> Protected View.

      a. Uncheck the "Enable Protected View for files originating from the Internet" and/or "Enable Protected View for files located in potentially unsafe locations"

       

Exporting to Excel when using Google Chrome Browsers

If you are having trouble exporting to Excel on Google Chrome browser, this is by design. Older versions of Chrome did not have the ability to do this task. The newest version of Chrome has this ability built-in. You can also download and install different Chrome extensions to add various abilities that work with MS Office. See more at https://chrome.google.com/webstore/search/excel?hl=en