Consulting

Results 1 to 6 of 6

Thread: How to stop following start-up message?

  1. #1

    How to stop following start-up message?

    Dear all, each time I open my excel file, I get a start up message saying, 'this workbook contains links to other data sources............. (update) (dont update) (help)'

    Is there any possibility to stop this message appearing with default 'update' to be selected?

    I am using excel 2010 in windows 7 home basic.

    Thanks for your help.

  2. #2
    VBAX Regular
    Joined
    Feb 2012
    Posts
    31
    Location
    1. Click Microsoft Office Button, and then click Excel Options.
    2. Click Advanced.
    3. Under General, click to clear the Ask to update automatic links check box.
    This works for 2007, 2010 should be the same.

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Not a good idea in my view. What if a workbook has links it shouldn't have, how will you know?
    Last edited by Bob Phillips; 03-10-2012 at 09:14 AM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  4. #4
    VBAX Regular
    Joined
    Feb 2012
    Posts
    31
    Location
    Quote Originally Posted by xld
    Not a good idea in my view. What if a workbook has links it shouldn't have, how will you now?
    He asked for an answer, I gave it. What more can I do?

  5. #5
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    I was directing it at him.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  6. #6
    VBAX Regular
    Joined
    Feb 2012
    Posts
    31
    Location
    Quote Originally Posted by xld
    I was directing it at him.
    Fair enough :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •