Hi Guys,

I'm currently creating a schedule that has a workbook that references many other different workbooks...The only issue is that this schedule is needed for many projects, so I copy & paste a 'master' root folder that contains all the workbooks to a new file location on the computer to use for that specific project.

Each time I do this the cell references still use the original master workbooks, because they use absolute references opposed to local ones. And I haven't figured out how to have them automatically update so they don't use :U\\folder1\folder2\etc... and instead use /folder2/folder1\folderA\etc...

Hyperlinks seem to update fine, it's just the references in the cells that I can't get to change.

Thanks in advance!

Alistair