December 13, 2004, 11:25 AM
CHERIWF Excel in Browser vs Excel
Greeting Everyone:
Just a question. When running a WebFocus report in which the output is in Excel some of the users are having the report open within a browser window while others are having the report open within the excel tool itself. When opening in the browser window the users must copy the data and then paste to excel in order to do any sorting, etc .... Has anyone experienced this before or know why this is happening ?
December 13, 2004, 02:10 PM
susannahits not excel , its xml in a web viewer.
If your users get the pop upwindow asking if they want to save or open the excel file , then they can click save, and and they must save it as .xls. If your users have nuked that popup window by having ever de-selected the box 'always ask', then they'll get xml in a web viewer , meaning it doesn't open in excel directly.
we get around that by having users rcxx (which is right click export to excel). we're in an all-winxp environment. works fabulously.
December 13, 2004, 02:14 PM
<Grzegorz>There is a setting of the user's workstation which controls whether documents are open within the browser window.
You can look at the
Microsoft article explaining the setting (datails may vary depending on the windows version).
Hope this helps
Grzegorz
December 14, 2004, 07:16 PM
SpenceIn order to display an Excel report in a separate window you can do the following:
1. Go into Windows Explorer � Right Click Start � Click on Explorer
2. Click on Tools
3. Click on Folder Options
4. Under Folder Options � Click on the File Types Tab
5. Under File Types look for .XLS extension
6. Next Click on the Advanced Tab button and uncheck �browse in same window�
7. Click OK
December 15, 2004, 07:10 PM
susannahThanks Gregorz and Spence. I didn't know how to do that. Appreciate the post. That'll make a huge improvement at this site.