Export excel to Pivot table issue

[Former Member]

Hello Folks,

Our Business user has a problem with the exporting to excel as Pivot table. Now, the user is trying to do, List - Export - Spreadsheet, and she is getting "Save XXL list object in SAPoffice". How can we get the option to save in "Excel in XXL format" to get to the Pivot table..

Thank You.

[Former Member]

hi,

check out this [LINK|http://sample-code-abap.blogspot.com/2009/05/reset-alv-export-option-for-user.html]

the report SALV_BS_ADMIN_MAINTAIN is used to reset this setting. It's easy, run the report, select and delete the record for the specific user from report output and that user will get the dialog again.

[Former Member]

Hello,

I tried to execute the report which you have given, but, in that report I cannot see my user name as the Pivot table setting is defaulted. Can I know what exactly this program does?

[Former Member]

Hello,

We have used program SALV_BS_ADMIN_MAINTAIN to reset the setting, but, now the user is getting the pop-up as "Save XXL list object in SAPoffice". Any idea why this is coming up and how to reset this? Please let me know

[Former Member]

Hello,

My user is still facing the same issue "Save XXL list object in SAPoffice" and one more thing, if it is GUI issue, how come this user is facing the same problem when this user is getting the same error on other laptop too? Please suggest.