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

Can't export to Excel from SAP after upgrade

Hi there,

We couldn't export to Excel after upgrading SAP from 2007B PL15 to 8.81 Pl07.

We tried all workstations as well as server itself and encountered below error upon exporting to Excel.

"AutoOpen.xls cannot be accessed. The file may be corrupted, loated on a server that is not responding, or read only."

Microsoft Excel Folder under "General Settings >> Path tab" has been defined.

If you have a solution or workaround for the above error, kindly share with me.

Thank you.

Regards,

Yadana

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2011 at 01:47 AM

    Hi,

    Reinstall also the Microsoft Excel it need to update also.

    Check excel settings for macro settings set to Low or disabled.

    Thanks.

    Clint

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2011 at 01:25 PM

    Hi Yadana,

    Check if you can open this AutoOpen.xls directly from the location currently in.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2011 at 03:40 PM

    Hi Yadana.......

    I guess there might be some configuration issue after DB Upgradation.

    I would suggest you to please reconfigure the Paths in General setting under Path Tab.......

    Also check the same with super user's ID........

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2011 at 07:57 AM

    Have you checked at the end of your path to see if you do have an autoopen.xls file?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2011 at 04:24 AM

    Dear Yadana,

    Check this forum

    export-to-excel-doesn't-work-anymore

    Regards

    Mangesh Pagdhare.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      Thank you all for your suggestions.

      The issue was resolved after I replaced the "AutoOpen.xls" on the "
      SAPSERVER\B1_SHR\ExclDocs\" with a copy from my notebook.

      Think the original file got corrupted after the upgrade.

      Yadana

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.