In BPS Manual Planning, Excel 2007 window takes focus away from SAP GUI

[former_member581688]

We have a planning folder set up with multiple input layouts. Users with Excel 2007 are having issues displaying and switching layouts within the folder. When the user goes into the folder, an Excel window opens external to the SAP GUI window. The Excel window is given focus over the GUI window - so the user has to switch back to the SAP GUI window to see the planning layout. Then when they want to switch to a different layout within the same folder, the external Excel window is closed and reopened and again. Again, focus changes to the external Excel window so that the user has to switch back to the SAP GUI window.

We did not experience this behavior with Excel 2003.

Has any one else had this issue with Excel 2007? Did you find a way to resolve it? If so, how? Any suggestions would be greatly appreciated.

Regards,

Shannon

[desgallagher · Accepted solution]

Hello Shannon,

This is a known issue:

This Phantom Excel Spreadsheet is an known Microsoft problem, I have

attached a video to the message in the sapmats link below

(see the file attachment EmptyExcel.rar)

that involves the creation of the problem without the involvement of

any SAP software. Can you follow the steps in the video and check if

you can reproduce the problem in your system using these steps.

If you can reproduce using the steps then please raise a ticket with

Microsoft for this issue,since the issue is independent of SAP software

we would not be able to provide a fix.

SAP MATS link:

https://sapmats-de.sap-ag.de/download/download.cgi?id=809ONGO6GSYNT

HLZM48EF36PWP5RJ1MU659BTMQ4VU7NPEHITR

Best Regards,

Des

[former_member581688 · Accepted solution]

Hi, Des,

Thanks for the response! I downloaded the file from the link you provided. However, when I try to open the .zip file, I get an error that the file is invalid or corrupted. Is there another method by which you can provide the file?

Regards,

Shannon

[Former Member · Accepted solution]

Download winrar from http://www.rarlab.com/download.htm and u should be able to view this file... I got the same error and was able to download it after I installed Winrar x86(32 bit) 3.93 and it worked fine

[former_member581688 · Accepted solution]

Thanks, Ali. Once I installed WinRAR, I was able to open the file.

[former_member581688 · Accepted solution]

Des,

I recreated the steps in the video. When I embedded an Excel file without macros, I did not get an empty Excel window. But when I found an Excel file with macros to embed, an Excel window was opened and remained open.

I will look into logging this issue with Microsoft.

Thanks!

Shannon

[former_member269100 · Accepted solution]

Hi Des,

Is this SAP MATS link still valid? I tried accessing it but it says "Error - download expired". Can you point me to a valid document please?

Thanks,

Aloy

[Former Member]

Anybody has found a solution for this problem. We are experiencing the same issue.

Thanks !