Link to other worksheet fails.
 

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.

Link to other worksheet fails.
 

Warren Easton wrote:
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?


I think you need to tell Excel to update external link values. In 2003
It's Edit | Links | Update Values.

AFAIK, you can't make this link "live", but you can tell the requesting
sheet to automatically update external values when it is opened.

Link to other worksheet fails.
 

Do you know how to get this in 2007?
--
Regards
Warren
Excel Novice
Addiewell, Scotland.



"smartin" wrote:

Warren Easton wrote:
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?


I think you need to tell Excel to update external link values. In 2003
It's Edit | Links | Update Values.

AFAIK, you can't make this link "live", but you can tell the requesting
sheet to automatically update external values when it is opened.

Link to other worksheet fails.
 

Warren Easton wrote:
Do you know how to get this in 2007?

Sorry, no. If no one else answers in this thread you might want to
repost the specific question "where is the link manager in Excel 2007?"

Best of luck!