Skip to Content
author's profile photo Former Member
Former Member

Unable to export data from SAP to excel

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 12:32 PM

    hi ,

    is it going to any short dump.

    if so specify the shot dump.

    regards,

    bhupesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 01:54 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 02:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 11:34 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 12:56 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.