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.

--
Regards,
Tom Ogilvy

John Wirt wrote in message
...
Can a VBA routine be written to change external links to manual updating
after they have been initially created in a workbook and that workbook has
been closed?

I would like to write a VBA procedure that can be included in a workbook
template so that external links created in any workbooks created from the
template can be manually changed from manual to autmatic updating.

Is this possible?

John Wirt