Updatelinks:=0
would seem to follow VBA's help.

If the other workbooks are open, then excel will update the links? Could that
be the problem?

How do you know that the links are trying to be updated?

If you're seeing an error message instead of the old value that was there...

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

SandyR wrote:

I am trying to open spreadsheets in VBA without updating the links. I have
tried several different syntaxes to prevent the update, but it still tries to
update when it opens. The relevant code is:

Set sourcebook = Workbooks.Open(fnames, UPDATELINKS:=False)

Fnames is derived from cells in the worksheet. I have tried setting
updatelinks as an integer variable and setting it to zero. I have also tried
substituting xlupdatelinksnever for the UPDATELINKS:=False. Can someone
suggest an alternative that will work?

Thanks in advance for your help!

--

Dave Peterson