Embedded Excel in SAP Reports

How to embed Excel in SAP so that it does not pop-up a new Excel worksheet?

This need to be done in Microsoft Excel.

Before doing, you need to logoff SAP and close SAPGI.

Open Excel 

Click File Options  

 Excel File Options

Under the User Interface options, tick Optimize for compatibility (application restart required)

Excel Optimize for Compatibility

Next under Excel Options

Click Trust Center - Trust Center Settings

Excel Trust Center

Tick Disable VBA macros with notification

Excel Disable VBA macros with notification 

You are done.

Sometimes, it takes about 3 minutes for the settings to take effect in SAP.

ABAP Tips

 

See Also
Estimate Guidelines for ABAP programs

Get help for your ABAP problems
Do you have a ABAP Question?

ABAP Books
ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books

More ABAP Tips

Main Index
SAP Basis, ABAP Programming and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.