Undo an option I turned on when exporting to spreadsheet

[former_member512181]

I clicked on the menu option List / Export / Spreadsheet. When the screen came up, I had the option to select what format. I selected a format and then checked a box that read to Always Use Selected Format. I want to get the option back to select another format and I can't -- I should not have checked the box -- how do I get the option back?

[Former Member · Accepted solution]

Hi

Go to MB51 run any list and then type &RESET_EXCEL into SAP command field

[Former Member]

Hi Carol. you need to delete entry in SALV_BS_ADMIN table (where M_USER is your login user) in the sap system where you select this.

Read the Note 1080608 - Defining ABAP ALV export format for spreadsheet

About report SALV_BS_ADMIN_MAINTAIN.

Regards.

[Former Member]

Hi... Is it possible to set the default system behavior to be the same for all users... we want XXL format.

I have been through 1080608 as well as 1157927 and its prerequisites, which were done. We are on ECC 6.0 and just applied support pack stack 12.

James

[former_member512181]

James -- here is a little Z program that one of our ABAP guys wrote to set everyone to use the XXL format -- try it out....

REPORT Z_DEFAULT_SALV_BS_ADMIN.

************************************************************************

• Default ALV export option to XLS

************************************************************************

DATA: W_ADMIN TYPE SALV_BS_S_ADMIN.

PARAMETER: P_OBJECT TYPE SALV_BS_OBJ DEFAULT 'GUI_ALV_XML_VER' OBLIGATORY.

PARAMETER: P_USER type SLIS_USER DEFAULT '*' OBLIGATORY.

PARAMETER: P_VALUE TYPE SALV_BS_VALUE DEFAULT '08' OBLIGATORY.

PARAMETER: P_CATEG1 TYPE SALV_BS_CONSTANT DEFAULT '01' OBLIGATORY.

PARAMETER: P_CATEG2 TYPE SALV_BS_CONSTANT DEFAULT '01' OBLIGATORY.

PARAMETER: P_DELETE AS CHECKBOX DEFAULT 'X'.

START-OF-SELECTION.

W_ADMIN-OBJECT = P_OBJECT.

W_ADMIN-M_USER = P_USER.

W_ADMIN-VALUE = P_VALUE.

W_ADMIN-CATEG_ONE = P_CATEG1.

W_ADMIN-CATEG_TWO = P_CATEG2.

W_ADMIN-ERFDAT = SY-DATUM.

W_ADMIN-ERFTIME = SY-UZEIT.

W_ADMIN-ERFNAME = SY-UNAME.

*Delete existing values

IF P_DELETE = 'X'.

DELETE FROM SALV_BS_ADMIN

WHERE OBJECT = 'GUI_ALV_XML_VER'.

ENDIF.

MODIFY SALV_BS_ADMIN FROM W_ADMIN.

IF SY-SUBRC = 0.

MESSAGE S000(OO) WITH 'SALV_BS_ADMIN'

'Record modified for user'

P_USER.

COMMIT WORK AND WAIT.

ENDIF.