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

Auto Open in Excel 2007

Hi,

Which options do I need to have set within Excel 2007 to allow me to Auto Open spreadsheets exported from SAP?

I have tried setting the Macro Security to "Enable all Macros" with "Trust Access to the VBA project object model" ticked to no avail

I have found notes relating to earlier version of Excel but not 2007.

Thanks

Greig

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2010 at 03:37 PM

    Hi Greig,

    What OS do you use? Auto Open is not a security issue but user right to the Autoopen.xls file. What path have you defined in your system for Excel files?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2010 at 12:20 AM

    Hi Greig,

    Make sure the autoopen.xls file is available in the path set for excel documents in the General Settings. This is usually the issue here.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2010 at 07:17 PM

    Hi.

    Try to add the folder where you save the Excel files in Thrusted sites tab, under Excel options.

    Also check your computer's regional settings match the SB1 settings for decimal and thousands delimitators.

    I hope this helps.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 12, 2010 at 07:16 AM

    hello Grieg,

    if u are using Win7 (this is also applicable in vista and xp)goto Control Panel -->> All Control Panel Items -->> User Accounts -->> Change User Account Control Settings... in the security bar put in the lowest (Not Recommended).. this will open the auto open in excel 2007.

    hope it helps.

    Fidel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2011 at 06:04 PM

    How does the Autoopen.xls file get created? I assume it is simply an empty file.

    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.