COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: vmjoe78 on 02 Aug 2011 06:48:04 AM

Title: Export to excel sheet 2002
Post by: vmjoe78 on 02 Aug 2011 06:48:04 AM
Hello Good Evening All,

I have a problem of exporting the analysis studio report to excel 2002, I am using the IE version of 7.0.5730 previously its worked fine suddely it says the page can not be displayed.

I have tried the IE Setting of
I have unchecked Don't save the encripted page to disk, file download enable, still its not working for me.

Any suggestions

Thanks and Regards

Joe
Title: Re: Export to excel sheet 2002
Post by: PolzovatelCognos on 02 Aug 2011 02:32:41 PM
From our experience, we had to have the following browser settings Enabled in our IE browser (IE8) in order for Cognos and Excel (Excel 2007 in our case, however), to function properly. (See below.) Are you able to export the report to -other- Excel versions? Also, -if- browser settings are setup correctly and have not been altered, perhaps a firewall on the Cognos server can be blocking the ability to export reports to the mentioned Excel format? What version of Cognos are you on?

~ ActiveX controls and plug-ins:
-   Run ActiveX controls and plug-ins
-   Script ActiveX controls marked safe for scripting
~ Downloads:
-   Automatic prompting for file downloads
-   File download
~ Miscellaneous:
-   Allow Meta Refresh
~ Scripting:
-   Active Scripting
~ User Authentication
-   Automatic logon with current user name and password
Title: Re: Export to excel sheet 2002
Post by: Islandgirl on 13 Sep 2011 08:18:06 AM
also make sure you have the site saved as a trusted site - whether internet or local intranet
I know if we don't have it saved as a trusted site Excel exports don't work properly.
just a thought  8)