topic Re: Export excel to Pivot table issue in Application Development and Automation Discussions

Export excel to Pivot table issue

Former Member — Wed, 12 Jan 2011 16:37:24 GMT

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.

Re: Export excel to Pivot table issue

Former Member — Wed, 12 Jan 2011 16:51:44 GMT

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.

Re: Export excel to Pivot table issue

Former Member — Wed, 12 Jan 2011 20:54:48 GMT

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?

Re: Export excel to Pivot table issue

Former Member — Mon, 24 Jan 2011 15:24:07 GMT

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

Re: Export excel to Pivot table issue

Former Member — Fri, 11 Feb 2011 13:43:13 GMT

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.