Skip to Content
Author's profile photo subha chakrapani

Data not displayed in Excel in ALV report

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
 
 
  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

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Which version of Excel and SAP GUI was used for this?

      Author's profile photo subha chakrapani
      subha chakrapani
      Blog Post Author

      Excel 2007 and SAP Gui 7.3

      Author's profile photo Former Member
      Former Member

      Unfortunately does not work. Did as it is written, used Office 2013

      Author's profile photo subha chakrapani
      subha chakrapani
      Blog Post Author

      Hi Oleg,

      After changing the setup. Come out of the report and execute the report and try downloading the data into excel .

      Thank you,

      With Regards

      Subha

      Author's profile photo Former Member
      Former Member

      Yes, I even restarted the local station. These are not displayed in an Excel spreadsheet

      Author's profile photo subha chakrapani
      subha chakrapani
      Blog Post Author

      Which item?

      Author's profile photo Former Member
      Former Member

      Nice...helpful

      Author's profile photo Shristy Priyadarshi
      Shristy Priyadarshi

      For me data is still not displayed,
      Any leads please.

      Thanks in advance!