In the ..excel.links group, Bill Manville MVP - Microsoft Excel, Oxford,
England, says that there is an Excel 4 command that works:

- - - - - - - - -
VBA does not have a method of its own to change the update method of a
link.

However, you can use a VBA statement that executes an Excel 4 macro that
will do the job for you while the workbook is open (I discovered this by
recording a macro while changing a link's update method)

V = ThisWorkbook.LinkSources(xlOLELinks)
' change to manual updating
ExecuteExcel4Macro "SET.UPDATE.STATUS(""" & V(1) & """,2,2)"
- - - - - -
However, this macro will not run as a VBA procedure, no matter how I try to
define V as a variable.

What are Excel4Macros?

John Wirt
- - - - -
"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.

--
Regards,
Tom Ogilvy