confused on links across other workbooks

[MikeR-Oz]

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

 

[Dave Peterson]

I'm guessing that you have two workbooks open--but in different instances of
excel.

(If you update the "sending" workbook, then save, then recalc the "receiving"
workbook, then you'll see the correct value.)

But if you open both workbooks in the same instance, then the change will be
immediate and your formulas that point at the sending workbook (in the receiving
workbook) will drop the drive/path that point at the sending workbook.

Close the sending workbook and its instance of excel.
Then use file|open (in xl2003 menus) in the remaining instance to test it.

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