One of our users has approx 60 spreadsheets with various links between them.
They were all in one folder on the server named ABC. Now the folder has been
renamed to DEF. Now when opening one of these spreadsheets, the user gets a
message saying "this workbook contains one or more links that cannot be
updated"...choose between Continue and Edit Links. It's obvious why this is
happening but is there an easy way to update all 60 spreadsheets to reflect
the new folder name?