Update Links Automatically

[John]

Running Excel XP and was wondering is there a setting which will
automatically update any external links that I have referenced, without the
dialog option of "Do you want to update links" etc

Thanks

 

[Dave Peterson]

There's a setting you can toggle.

Tools|options|edit tab
Uncheck "Ask to update automatic links"

Then the prompt goes away, but the links are updated.

This is your own setting--it affects all the workbooks you open, but won't
affect anyone else when they open that workbook. (They'd have to change their
setting, too.)

 

[John]

Thanks Dave

There's a setting you can toggle.

Tools|options|edit tab
Uncheck "Ask to update automatic links"

Then the prompt goes away, but the links are updated.

This is your own setting--it affects all the workbooks you open, but won't
affect anyone else when they open that workbook. (They'd have to change
their
setting, too.)