When I try to edit links referencing various spreadsheets on our network, a window pops up for each cell with a link, requiring that the file be selected from the network folder / location.
In the past I've been able to just do a "global" change in the like file location and the spreadsheet would update for the new file... but now each time I'm prompted to define the file.
There are literally thousands of cells with links to update and so it's impractical to do it manually. Any feedback about this would be greatly appreciated.
Bookmarks