📎 AI Summary:
The thread discusses an issue where a blank Excel sheet opens before SAP reports display in Excel 2007 after upgrading to Windows 7 and Office 2007, a problem not present in Windows XP/Office 2003. The original poster seeks advice after SAP support's suggestions—upgrading to Office 2010 or uninstalling Service Pack 2—failed to resolve the issue. A subsequent contributor suggests adjusting Excel's macro and ActiveX security settings, while another expresses frustration with SAP's newer version, criticizing its performance, especially in warehouse and parts management. Overall, the conversation reflects troubleshooting efforts and dissatisfaction with SAP 6.0's performance.
A

asap01

New Member
Member details
Joined
Oct 19, 2010
Messages
2
Thread Author #1
Hello,
We recently have new system with Windows 7 and Office 2007 installation. We installed SAP ECC 6. 0 and SAP GUI 7.20 with the latest Path (Patch Level 3). Most of the standard SAP reports are built with Excel features. When we run any of these reports, a blank Excel sheet is always opened before the report is displayed in Excel 2007 format. This was not the issue with Windows XP/Office 2003.
After contacting SAP support the following recommendations were suggested based MSDN KB Article 2009802:

1. Upgrade to Office 2010 or higher.
3. Uninstall Service Pack 2 from Office 2007.

We tried both the solutions and the issue still remains the same. It is going to be inconvenient for users to keep closing the blank excel sheet every time they run the report or multiple reports.

Please advise.

Thanks & Regards,
A SAP
 

Solution
Trouble
Since the knowledge base article seems to associate this behavior with OLE calls to object with either built in macros or activeX controls, have you considered making adjustments within Excel 2007 on the individual machines as to how they handle security settings regarding macros and activeX, you can make such changes from within the "Options" "Trust Center" "Trust Center Settings" button. Not sure if it will help in your particular case, but it might be worth looking into.
Sort by date Sort by votes
Trouble

Trouble

Noob Whisperer
Member details
Joined
Nov 30, 2009
Messages
13,723
#2
Since the knowledge base article seems to associate this behavior with OLE calls to object with either built in macros or activeX controls, have you considered making adjustments within Excel 2007 on the individual machines as to how they handle security settings regarding macros and activeX, you can make such changes from within the "Options" "Trust Center" "Trust Center Settings" button. Not sure if it will help in your particular case, but it might be worth looking into.
 
Upvote 1 Downvote
Solution
V

Veegertx

Extraordinary Member
Member details
Joined
Nov 19, 2009
Messages
446
#3
Blame it on something else yeah right
SAP = Sorry A$$ program
They upgrade ours to 6.0 also
They say this works great for the number punchers who wants to see graphs and such but from my end it is total crap. Warehouse and parts it sucks.
 
Upvote 0 Downvote
You must log in or register to reply here.