Excel links (changing names & moving folders) | Excel forum

Losing links when Changing spreasheet names :
I have several spreeadhseets that are linked together - I want to change the name of the spreadsheets however when i do I lose the links between the various spreadsheets - is it possible to change the name of linked spreadhseets without losing the links and having to manually update the links??

Losing links when Moving folders :
Also, it is possible to copy a folder of spreadsheets to another folder, rename the spreadsheets in the new folder and have the links automatically update (I have tried and have the same issue, when I move the spreadsheets the links still point to the original folder and file name)

Thanks
NICK