ALV Formatting Issue

[Former Member]

Dear Experts,

There is issue with ALV report, I dont want to download Spreadsheet from local File option from the header of ALV . Spreadsheet is in greyed mode.  Please find the below screen shot for same.

Kindly Suggest the solution.

Regards,

Gaurav

[Former Member]

Dear Experts,

There is issue with ALV report, I dont want to download Spreadsheet from local File option from the header of ALV . Spreadsheet is in greyed mode.  Please find the below screen shot for same.

Kindly Suggest the solution.

Regards,

Gaurav

[Tomas_Buryanek]

Check your ALV consistency:

The Consistency Check - ALV Grid Control (BC-SRV-ALV) - SAP Library

In some cases inconsistency might cause "greyed out" export buttons.

[SwadhinGhatuary]

HI,

Most probable reasons are the final table may have a deep structure.

Make sure ..

[SwadhinGhatuary]

Hi,

                

                     Srinivas Chapa                    Feb 14, 2014 9:05 PM                                     (in             

Hello Maria,

seems you have selected the option as default and hence you are getting that option only

There are three ways to reset the default download option

1) Execute any ALV report on the output screen ,just do a right click ,your default settings will be reset automatically.

Other options along with the below one  to disable defaults set by the user.

2 )Maintain the table SALV_BS_ADMIN using the report SALV_BS_ADMIN_MAINTAIN.

Note 1080608 - Defining ABAP ALV export format for spreadsheet

3) "&RESET_EXCEL" in the command field to reset the parameter in the ALV list -Note  1157927

Anyof the above 3 will work

Regards,

Srini