External reference help

[jmenche]

Howdy,

I have a spreadsheet with a bunch of external references to a network drive. I want to globally change the network path, however, when I select all of the cells and use Replace it seems to go cell by cell and even wants to open up the source file. Is there a way to turn this off so I can do a simple replace and then turn it back on?

Thanks

Jeff

[ranman256]

You could run
Application.Calculation = xlCalculateManual
Application.AskToUpdateLinks = False
to turn off links and calcs, then try the replace.