[CLOSED] Problems opening report in Excel 2010

September 23, 2011, 02:41 PM

Wayne Atchley

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,

September 26, 2011, 07:17 AM

Jeff_f

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

September 26, 2011, 09:21 AM

TSU_Texan

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

September 27, 2011, 06:48 AM

Jeff_f

Unknown... as of yet we have not submitted this to IBI. Please let us know what they say in October.

Thanks

September 27, 2011, 11:10 AM

Francis Mariani

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

September 28, 2011, 02:44 PM

Jeff_f

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)"