PDA

View Full Version : External reference help



jmenche
09-22-2014, 11:17 AM
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
09-23-2014, 10:55 AM
You could run
Application.Calculation = xlCalculateManual
Application.AskToUpdateLinks = False
to turn off links and calcs, then try the replace.