Skip to Content
avatar image
Former Member

Undo an option I turned on when exporting to spreadsheet

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 18, 2010 at 08:48 AM

    Hi

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

    Add comment
    10|10000 characters needed characters exceeded

  • May 20, 2008 at 06:19 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.