|Subject:||Re: Updating Links|
|Posted by:||Dave Peterson (peters…@verizonXSPAM.net)|
|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.
> (using Excel2003 and XP)
> i have a wkbookA that has formulas in it linked to cells in wkbookB and
> 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
Updating Links posted by WhytheQ on 28 May 2006