If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Opening BI reports in Excel 2007

Started by MaxMSUmed, 07 Nov 2014 08:38:08 AM

Previous topic - Next topic

MaxMSUmed

Hi there.  I am using Firefox and I am having trouble having BI reports open automatically in Excel.  I was able to do this Monday afternoon but when I tried on Tuesday my report runs and then it just goes to a white screen.  I don't get a dialog box asking me if I want to open the report in Excel, I don't get anything.  Not sure why this has suddenly happened.  I checked my pop up blocker setting and it's not enabled.  I have tried to do the same thing in Internet Explorer and it does not work there either.  Our IT dept seems stumped.  Any suggestions?   (I can run the report in HTML and then chose to convert it to Excel as a work around but I would still like to know why one day I can open in Excel automatically and then the next day I can't).
Thanks for any help or ideas!

bdbits

If it worked one day and not the next, something changed in your computer. This kind of thing can be controlled by group policy if you are in a Windows environment, or perhaps updates were installed.

It works fine for me with the latest version of Firefox and Excel 2013. It is definitely a configuration issue.

MaxMSUmed

Thank you!  In IE the compatibility view was turned off and automatic prompting for file downloads was disabled (not a clue as to how that happened).  However, I've still not figured out what's wrong in Firefox. 

bdbits

Maybe it is actually downloading rather than saving it, but you do not realize it. In Firefox, click the stack of lines in the upper right that acts as a menu and select "Options", or pick that from the drop-down menus if you have them enabled. Go to the Applications tab. Look in the list for a Content Type of "Microsoft Excel Worksheet". If the Action is set to Save, it will simply save the file and not open it in Excel. You can find it under the downward pointing arrow in the upper right, or press Ctrl-J to open a window that lists downloads, among other things. See if your report shows up in that list after you run the report to Excel.