| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference to worksheet fails if row deleted | Excel Worksheet Functions | |||
| Hyperlink to renamed Worksheet fails | Excel Discussion (Misc queries) | |||
| Worksheet fails to filter at times | Excel Worksheet Functions | |||
| Macro fails when worksheet protected | Excel Discussion (Misc queries) | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
