Excel Report Issue

Microsoft released security updates that prevent HTML files with .XLS  extensions to be opened natively. This may not affect all clients, but only those who have recently installed one of the three Microsoft updates. For Informetica, this means that reports exported to Excel are affected. This is not a bug that Informetica introduced and it affects several other non-Informetica applications. 

Expected Behaviour

When opening an Informetica Excel report, you used to get the following message:

image

Current Behaviour

When opening an Informetica Excel report, you do not get any message and nothing is displayed. You only see a grey screen with no data. 

Steps to Unblock

Microsoft released an article  with possible workarounds while they work on a more permanent solution. We recommend that you use this unblock workaround until further notice. 

  1. Before opening the Excel file, click on the small down arrow beside the file name and select Show in Folder.
    image 
  2. Your report is automatically selected in the list of downloaded files. 
  3. Right-Click the Excel file and go to Properties.
    image
  4. Make sure you are in the General tab. Select Unblock and then Apply.
    image
  5. Open the Excel file.

References