What can't be done manually generally can't be done with code when it comes
to settings and so forth. reference changing a link from automatic to
manual - manual grayed out in the menu, can't be done.

--
Regards,
Tom Ogilvy
"John Wirt" wrote in message
...
Unfrotunately, no, I do not think that link updating can be turned off
using
any available menu selections.

John

"Tom Ogilvy" wrote in message
...
Excel likes to other excel workbooks are always automatic.

Beyond that, if you can do it manually, turn on the macro recorder and
you
have your code.