Sunday, 2 March 2014

Repairing Microsoft Excel for SAP ALV Data!!


This information is awesome and interesting too, Which I like to share in my blog.

Thanks to Subha Chakrapani. 

In ALV report , when we click on Microsoft Excel button(CTRL+SHIFT+F7) as shown below, the excel sheet does not display data.

Image1.JPG
  Initial output
  image 2.JPG
   
For data to appear here do the following :


1. Open Excel


2. Click on  Office Button at the top and click  > Excel Options

    Click onTrust Center as shown below:

image 3.png
  
  
3.Click on Trust Center Settings


image 4.jpg
4. Click on Macro Settings and Enable Trust Access

image 5.jpg

5. Then data will appear in the Excel:

image 6.jpg


No comments:

Post a Comment

Note: only a member of this blog may post a comment.