We have a set of spreadsheets that are linked for YTD and Performance information and calculations. There are 17 "stores" which fill in their monthly data and forward to the office for consolidation. The new months are copied into a master file of all stores. These files are linked to a YTD file. They all reside in a common folder. It seems when the folder is moved or copied the links do not get updated and therefore contain the old file references which are no longer available (change of computer or file location). This seems especially to occur if the set of files is sent by email and therefore packaged as zip files. EDIT LINKS straightens them out but takes an iterative execution (one per store). Is there any way to prevent this and if not a more global way to EDIT all links?