MS Patch prevents SNAPSHOT Excel exports
The MS bulletin https://support.microsoft.com/en-us/kb/3115322 which was released July 2016 mentions that the new behavior in Excel will be to prevent user from opening an html file saved with the .xls extension. There is no error message or yellow warning bar for protected mode displayed, just a blank instance of Excel is opened on the computer screen. Since the SNAPSHOT function with the formatedexcel parameter does exactly this, no exports are able to be opened directly.
One workaround is to manually unblock the file (properties, click the unblock button, OK then open the file) but this is obviously not an ideal solution for users who struggle with even the simplest of tasks at times.
A second work around is to add a trusted location on the user computer and require the user to save the file to that folder before opening the file. Again, not something that many users will understand or perform correctly.
The last option (besides of course uninstalling the patch) is to change over to using the EXCELEXPORT function which is now available. The problem with this is that legacy applications often would make use of multiple objects in the export document for a report and the SNAPSHOT function would export an entire document. The new EXCELEXPORT only exports a single object at a time. Short of going back to each export document and reworking them to use some combination of VERTCOMBINE/HORICOMBINE to result in a single object for EXCELEXPORT, multiple EXCELEXPORT calls with different target cell locations in a file and then developing a way to deliver the resulting export file to the client computer has anyone else found any other solutions?
For legacy applications, this seems to be an involved fix no matter the option selected.
- 526 views
- 1 version
- 2 replies
- 0 followers
- Posted By:
- Lyle Dean
- August 22, 2016
About this forum
- 38,565 views
- 292 topics
- 10 followers
Looking for something you can't find? Have a suggestion on how we can improve? We want to hear from you!