IBM Support

Download link does not display data in the spreadsheet if you Open, instead of Save.

Technical Blog Post


Abstract

Download link does not display data in the spreadsheet if you Open, instead of Save.

Body

You're working with Maximo and may have observed that the Download functionality and behavior for Internet Explorer has changed. Previously, clicking download gave users the option of opening the file or saving it. When choosing Open, the spreadsheet file opened directly, displaying the data on the List tab.

 

Now, when clicking Open, the spreadsheet file appears to open, but no data is displayed.

 

Then you wonder : Is there a security or other setting in Internet Explorer that is preventing the spreadsheet data from displaying?

 

The answer for that is :  This is not a Maximo issue. This is security setting in Microsoft Office applications.

 

In order to resolve this scenario and be able to view data in the spreadsheet when using the Download link in Maximo you should perform these steps :

 

1- Open MS Excel. 

2- Go to Options --> Trust Center --> Trust Center Settings --> Protected View 

3- Uncheck the following 3 options (all of them): 

"Enable Protected View for files originating from the Internet"
"Enable Protected View for files located in potentially unsafe locations"
"Enable Protected View for Outlook attachments"

 

4- Close Excel, close the Web Browser.

5- Test it to make sure it works.

 

For more information :
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-kb3115322-opening-downloaded-files/19b8ab42-d0c4-402d-aa79-ad86e191fcc9

 

See ya

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11112781