You can change the setting for you.

Tools|options|Edit tab
Uncheck "ask to update automatic links"

The links will be refreshed and you won't be prompted.

But this is a setting that's local to you--each user controls what he/she wants
to do.



ceemo wrote:

When i sign into my spreadsheet it asks whether i would like to update
links. Is there anyway to get this to auto update without it prompting
me. Basicaly taking away the choice from the user?

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=399731

--

Dave Peterson