Home > IT Answers > Microsoft Windows > Problem in Data Downlod from SAP to Msoffice 2007
Mkamil
5 pts.
 Problem in Data Downlod from SAP to Msoffice 2007
Excel 2007, Microsoft Excel, Microsoft Office, SAP, SAP Import/Export
Problem in Data Downlod from SAP to Msoffice 2007. If i use data export option from SAP to Excel 2007 a blank xls sheet open but no SAP data apear in sheet.

Software/Hardware used:
ASKED: May 8, 2008  6:49 AM
UPDATED: July 20, 2010  5:14 AM
RELATED QUESTIONS
Answer Wiki:
Hi Mkamil, I have the same problem that you. Had you find the solution?. Thank you in advance. Regards. Mkamil, follow these steps: Click on the Office Button (upper left)>> Excel Options>> Trust Center>> Trust Center Settings>> Macro Settings>> make sure that Enable all macros is selected as well as Trust access to the VBA project object model This should do the trick. Good Luck!
Last Wiki Answer Submitted:  August 11, 2009  6:57 pm  by  Largoman   15 pts.
All Answer Wiki Contributors:  Largoman   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi Mkamil,

You can fix your problem with patching your SAP Logon.
SAP Logon 710 need patch level 8 and SAP Logon 640 need patch level 23.

Thoink
 15 pts.
 

We had the same problem. Turn on macros not fixed it.

But when we install new SAPgui version.
Since Final Release 710
7100.3.13.3131
this problem was fixed.

Tolsty
 10 pts.
 

If you will be performing this procedure numerous times, then I suggest you use a 3rd party data migration software. Check out EzySolutions by Gesix. EzySolutions is a user and process efficiency tool that seamlessly integrates Excel with SAP to download, modify and upload any SAP R/3 data.

JoeA5
 30 pts.
 

…integrates Excel with SAP to download, modify and upload any SAP R/3 data.

…which is generally a very bad idea and should be avoided at almost all costs. Generally, it should be forbidden by any SAP administrator.

Tom

TomLiotta
 107,995 pts.