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 EditLinks 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