Re: Updating Links

Giganews Newsgroups
Subject: Re: Updating Links
Posted by:  Dave Peterson (peters…
Date: Sun, 28 May 2006

There's another setting that you should toggle:

Tools|Options|edit tab|uncheck "Ask to update automatic links"

If you're sharing the workbook with others and expect the same behavior, you'll
want to know that this is a user-by-user setting.  Each user would have to
toggle this off.  And it affects all workbooks opened by the user, too.

WhytheQ wrote:
> (using Excel2003 and XP)
> i have a wkbookA that has formulas in it linked to cells in wkbookB and
> wkbookC
> when book A is opened the warning about "Do you want to update links
> blah blah...." appears even though I have gone into Edit>Links and on
> 2003 there is an option to automatically update links and do not warn
> user, which I have checked, I've checked this box for all links but
> still when the user opens the book the message appears.
> would the problem be that i have an autoopen routine in the workbook?
> any help greatly appreciated
> jason


Dave Peterson


In response to

Updating Links posted by WhytheQ on 28 May 2006