Is there a way to copy a spreadsheets (containing links) from one folder to another folder (and it automatically updating the links)? For instance I have a 2008 folder with excel spreadsheets (2008 A and 2008 B - containing links) and I want to create a new 2009 folder and have the same spreadsheets in it, however I want the 2009 A and 2009 B to link themselves together. If I just copy the 2008 spreadsheets into the 2009 folder, the links still revert back to the original 2008 spreadsheets.