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
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