on 05-19-2008 7:59 PM
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?
Hi
Go to MB51 run any list and then type &RESET_EXCEL into SAP command field
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.