How to update multiple links in multiple spreadsheets followin mo.
 

I have 100+ spreadsheets which link to a handfull of spreadheets which
contain yearly updated information. Each year I need to copy the spreadhseets
to a new folder structure. When I do this they still point to the original
folders (and therefore the previous years information) and I'm finding that I
need to go in manually and update the links. Is there an easier way of doing
this ? Can I put in relative links rather than absolute links ?