Unable to export data from SAP to excel

[Former Member]

hi ,

Impossible to use SAVE TEMPLATE AS FILE in layout

When using "save as file" option in layout mode, data is not correctly transferred to Excel.

like query data unable to export to excel ..

could you please guideme on this

regards

va

[former_member829550 · Accepted solution]

hi ,

is it going to any short dump.

if so specify the shot dump.

regards,

bhupesh

[Former Member]

Hello,

If the authorization is correct. Try re-installing SAP Gui and apply the latest patch and check.

<Deleted by Moderator>

See the "Rules of Engagement"

Regards,

prashant

[Former Member]

Hi,

Trust access to the VBA project object modelu201D setting within Office 2007 to enabled. This setting has been turned off by default from versions of Office 2003 onwards. This setting has been added to the group policy used to centrally configure Office 2007 within the model office environment.

Please read SAP Note 1094693.

Also Below notes are useful 696069 - No data when view Excel Inplace on ALV with Office ...

Please check for import the following notes:

1115435 - ALV export: Problems with Excel inplace

339830 - Excel inplace in ALV only delivers an empty sheet

Regards

Santosh

[Former Member]

Hi

After u see the file enter %pc in your command box.

It will prompt u to save the file in which document type select it and it is done.

as in ur case

the file may be read write protected.

Regards

Bhaskar

Edited by: bhaskar1818 on Aug 8, 2008 8:23 PM

[Former Member]

Hi,

Might be an authorization problem that is S_GUI auth object might be missing.Or can also be a problem with sapgui update it to current patch level.

Regards,

Vamshi.