All

Is it necessary to write a script to update links in cells refering to
other workbooks
when the files are moved to a new drive letter but the folder structure
remains the same
Are the links always relative to the current file and thus there is no
need to hardcode an absolute file path to the new drive :ie
"N:\FolderA\FolderB\MyWorkbook..."

When "\FolderB\MyWorkbook.." will do

Thanking you

Tony