Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Problems opening report in Excel 2010

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Problems opening report in Excel 2010
 Login/Join
 
Silver Member
posted
We have several reports set to open in Excel using the EXL2K format. These reports have worked great over the years, but we recently started upgrading computers to Windows 7 running Office 2010. When a user on these new Windows 7/Excel 2010 machine runs one of our excel reports they are prompted to log in to the server where WebFOCUS server is installed.

When I try to log in to the server, it does not accept my credentials...

I am not sure if this is a Windows 7 problem, an Excel 2010 problem, or a combination of the two... Unfortuantely, I do not have any machines where I can test Windows 7 with Excel 2007 or Windows XP with Excel 2010.

Has anyone encountered this situation? Is there a work around? I've search Focal point, and didn't find anything like this, but I might be looking for the wrong problem.

Any help is appreciated.

Wayne

Version: 7610_hotfix - Gen: 16 - Date: Dec 15, 2009 9:19:47 AM CST
Dev Studio: 7610
Server: Windows 2003

This message has been edited. Last edited by: Kerry,
 
Posts: 35 | Registered: April 20, 2006Report This Post
Member
posted Hide Post
We have the same issue. The only work around we have found is to click cancel on the login window. After that Excel's dialog box confirming to open WFSevlet.xls is typically hidden behind other windows. Once you click OK the report opens within Excel.

We are also on Dev Studio 7.6.10, Windows 7, Office 2010.

Jeff
 
Posts: 18 | Registered: January 12, 2011Report This Post
Member
posted Hide Post
Thanks for the reply. I will give this a try... Do you know if this is a support issue we can submit to IBI, or is this a Windows/Office security related bug/issue?

We are having IBI come on site to assist with an upgrade in October, so maybe we can have them take a look then...

Thanks again,

Wayne


WF 7.6.10
Dev Studio 7.6.10
Windows Server 2003
all output (Excel, HTML, PDF)
 
Posts: 3 | Registered: May 06, 2010Report This Post
Member
posted Hide Post
Unknown... as of yet we have not submitted this to IBI. Please let us know what they say in October.

Thanks


WebFOCUS 7.7.03
Windows, Outputs: HTML, Excel, PDF, Active HTML
 
Posts: 18 | Registered: January 12, 2011Report This Post
Expert
posted Hide Post
I've heard of a potential workaround that *might* work - in Windows 7, change the compatibility mode of Excel (and/or PowerPoint) to 'Windows Server 2003 (Service Pack 1)'.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
That worked for me. Thanks Francis!

For those who don't know how to do this (I had to ask as well) here's the steps...

Right-click on the Excel.exe file in C:\Program Files\Microsoft Office\Office14, select Properties, Compatibility tab, check the "Run this program in compatibility mode for:”, then select "Windows Server 2003 (Service Pack 1)"


WebFOCUS 7.7.03
Windows, Outputs: HTML, Excel, PDF, Active HTML
 
Posts: 18 | Registered: January 12, 2011Report This Post
Gold member
posted Hide Post
For my Windows 7 computer I set my compatibilty to Windows 7 and that worked also.
 
Posts: 60 | Location: Ellensburg Washington | Registered: May 22, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Problems opening report in Excel 2010

Copyright © 1996-2020 Information Builders