This question is a bit long winded, but I hope someone can help.

I have a Workbook thats linked to another work book on the server at work
€œP€� drive.
When I open the first work book €œBill Sheet Log€� and go to the cell €œC2€�
thats linked to the other sheet €œTwinwire Estimating Sheet€� the formula
looks like this- ='P:\Contracts Quoted\Twinwire Pitch\[Twinwire Estimating
Sheet.xls]Start Sheet'!$C$5. If I open €œTwinwire Estimating Sheet€� first then
go to open €œBill Sheet Log€� the formula looks like this-
='\\wm01srv\public\Contracts Quoted\Twinwire Pitch\[Twinwire Estimating
Sheet.xls]Start Sheet'!$C$5.
When they are both like this and I change [Twinwire Estimating
Sheet.xls]Start Sheet'!$C$5.
€œBill Sheet Log€� C2 doesnt change, but sometimes when both are open the
formula looks like this- ='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5
and when the formula is like this €œBill Sheet Log€� C2 changes when I change
€œ[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5€�.
My question is what do I need to do so the cell changes every time I change
the other cell, can I lock this link?

--
Thank you in advance for any help.

Regards
Warren
Excel Novice
Addiewell, Scotland.