I am trying to run a report in Excel from the html output or the run options selection in Cognos. What happens is that a window pops up starting to run the report but then the window disappears. There is no message on the screen or behind any windows. It is like Cognos can’t find Excel. I tried every version of Excel available from Cognos. I can open up Excel by itself and it runs just fine. I have Excel 2003 on my pc. If I login to Cognos on another pc the report will run just fine in Excel. Has anyone experienced this? Any Suggestion? Thanks in advance.
Without wishing to make myself look daft by suggesting something that you have already looked at, but its not going to be something like a pop up blocker is it? I quite often have end users come to me with that issue and it may not just be the default IE pop up blocker being given access to the Cognos URL but also third party pop up blockers which are part of toolbars that are long since forgotten about (e.g. Yahoo toolbar with integrated pop up blocker etc)
B
Try the steps below,
In Internet Explorer, from the Tools menu click Internet Options, Advanced Tab. Under the Security section clear the Do not save encrypted pages to disk check box.
If the problem persists, try adding the web site into Trusted Sites.
In Internet Explorer, from the Tools menu, click Internet Options -> Security Tab, then click Trusted Sites -> Sites and add the web site
This worked for us..Tool->Internetoptions->security->custom level ->automatic prompting of file downloads - Enable
->File download - enable.
Hope this helps.
KK
This happens to us intermittantly. Some users don't get the pop up box to open or save. We think it may be a windows/office problem on some machines and have another group looking at it. We tried reinstalling IE and office, and checking the pop up blocker, and nothing seems to help.
Now there is an issue with Excel multi sheet - it will lock your machine if you try to run to multi sheet rather than single sheet and you are running XP. Try running to Excel single sheet first.
hope this helps, and I'll let you know if our desktop group finds anything.
For us also this is happening when there is another Excel sheet open in the system or when we select Excel 2000. we are don't get this error if we use excel 2002 and we close other Excel sheet open in the same system.