Hi, I have 2 workbooks opened and the cell in the workbook that I am
changing shows :-
='C:\TEST Roster Projections\[PTO Projection ST Ives 06_09_20081TEST.xls]6
WEEK ROSTER'!L10

However the value that it places in the cell is not the correct one so I
copied and paste / link from the second workbook and then it is correct YET
the path is the same especially the last part being 6 WEEK ROSTER'!L10,

(SEE BELOW NEW PATH TAKEN FROM THE FORMULAE WINDOW)

with only the c drive and folders leading to the file being different - so
why did it not correct it ??

='[PTO Projection ST Ives 06_09_20081TEST.xls]6 WEEK ROSTER'!L10

Mike