Hi,
I have a spreadsheet with a lot of external references to a file on a network. I want to change the network path. However, when I select all cells and use the built-in Replace function, it wants to go cell by cell and open the source file. Is there a way to turn this off so I can do a simple text replace?
Thanks
Jeff
I have a spreadsheet with a lot of external references to a file on a network. I want to change the network path. However, when I select all cells and use the built-in Replace function, it wants to go cell by cell and open the source file. Is there a way to turn this off so I can do a simple text replace?
Thanks
Jeff