Hi

We have a series of linked workbooks, some in subdirectories, which get
copied each time we start a new project. The files do not get renamed. I'm
wondering if there is anyway to get the links in the copied workbooks to
update to point to the new directory they're in without resorting to opening
every linked workbook.

At the moment the links keep pointing back to the originating directory and
have to be manually updated using the Edit Links function.

We're using Excel 2007.

Thanks in advance

Jane