Hi
I'm trying to update a spreadsheet with a lot of external links, I've tried to do it using the Edit Links button but it just hangs.
I'm now trying to do it on another offline machine by using Find and Replace to change the network path and filename to the new location, I've turned off Automatic Updates, but it still asks me to point to the new file on every cell.
Is there a way to just get it to change the links in the cell without trying to access the new location ?, or is there a macro i can use to auto-click Cancel every time the dialogue box pops up ?
Thanks in advance for your help.
Kind Regards
Gavin
I'm trying to update a spreadsheet with a lot of external links, I've tried to do it using the Edit Links button but it just hangs.
I'm now trying to do it on another offline machine by using Find and Replace to change the network path and filename to the new location, I've turned off Automatic Updates, but it still asks me to point to the new file on every cell.
Is there a way to just get it to change the links in the cell without trying to access the new location ?, or is there a macro i can use to auto-click Cancel every time the dialogue box pops up ?
Thanks in advance for your help.
Kind Regards
Gavin
