| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links between Sheets
Dear All,
I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Dear Warren
= then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
like this
=Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Sorry Stew,
I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Dear Warren
This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Thanks Stew,
My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Maybe I am Misunderstanding
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 In one work book will pick out the value in C111 in another work book. If the value in C111 changes then that will be reflected in the original wookbook. Is this what you are after? Best Stew "Warren Easton" wrote: Thanks Stew, My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Yes and it works when I first set it up, but if I close the workbooks then
re-open them It doesn't change and it looks as if the link breaks down somwhere. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Maybe I am Misunderstanding ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 In one work book will pick out the value in C111 in another work book. If the value in C111 changes then that will be reflected in the original wookbook. Is this what you are after? Best Stew "Warren Easton" wrote: Thanks Stew, My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Can you give me a copy of the link
and are you saving after you enter the path Best Stewart If this helps please click the Yes button. "Warren Easton" wrote: Yes and it works when I first set it up, but if I close the workbooks then re-open them It doesn't change and it looks as if the link breaks down somwhere. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Maybe I am Misunderstanding ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 In one work book will pick out the value in C111 in another work book. If the value in C111 changes then that will be reflected in the original wookbook. Is this what you are after? Best Stew "Warren Easton" wrote: Thanks Stew, My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5
Yes I am saving the the workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: Can you give me a copy of the link and are you saving after you enter the path Best Stewart If this helps please click the Yes button. "Warren Easton" wrote: Yes and it works when I first set it up, but if I close the workbooks then re-open them It doesn't change and it looks as if the link breaks down somwhere. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Maybe I am Misunderstanding ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 In one work book will pick out the value in C111 in another work book. If the value in C111 changes then that will be reflected in the original wookbook. Is this what you are after? Best Stew "Warren Easton" wrote: Thanks Stew, My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
If you remove :$D$5 from the routing the all works fine for me
With the reference you are using to Twinwire Estimating Sheet.xls you asking for a 2 cells to be displayed in on cell. If that is what you want then ='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5&" "&'[Twinwire Estimating Sheet.xls]Start Sheet'!$D$5 Does it As for the Opening and Shutting of the worksbooks my examples work fine Let Me Know Stew "Warren Easton" wrote: ='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5 Yes I am saving the the workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: Can you give me a copy of the link and are you saving after you enter the path Best Stewart If this helps please click the Yes button. "Warren Easton" wrote: Yes and it works when I first set it up, but if I close the workbooks then re-open them It doesn't change and it looks as if the link breaks down somwhere. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Maybe I am Misunderstanding ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 In one work book will pick out the value in C111 in another work book. If the value in C111 changes then that will be reflected in the original wookbook. Is this what you are after? Best Stew "Warren Easton" wrote: Thanks Stew, My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
Hi Stew,
This could be the problem the cells are merged, but I've taken $D$5 away and it seems to be working. Thank you for the time you spent on this. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: If you remove :$D$5 from the routing the all works fine for me With the reference you are using to Twinwire Estimating Sheet.xls you asking for a 2 cells to be displayed in on cell. If that is what you want then ='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5&" "&'[Twinwire Estimating Sheet.xls]Start Sheet'!$D$5 Does it As for the Opening and Shutting of the worksbooks my examples work fine Let Me Know Stew "Warren Easton" wrote: ='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5 Yes I am saving the the workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: Can you give me a copy of the link and are you saving after you enter the path Best Stewart If this helps please click the Yes button. "Warren Easton" wrote: Yes and it works when I first set it up, but if I close the workbooks then re-open them It doesn't change and it looks as if the link breaks down somwhere. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Maybe I am Misunderstanding ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 In one work book will pick out the value in C111 in another work book. If the value in C111 changes then that will be reflected in the original wookbook. Is this what you are after? Best Stew "Warren Easton" wrote: Thanks Stew, My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links between Sheets
I have been helped so many times on this site , its good to give back
Merry Christmas from The Island Of Cumbrae Stew "Warren Easton" wrote: Hi Stew, This could be the problem the cells are merged, but I've taken $D$5 away and it seems to be working. Thank you for the time you spent on this. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: If you remove :$D$5 from the routing the all works fine for me With the reference you are using to Twinwire Estimating Sheet.xls you asking for a 2 cells to be displayed in on cell. If that is what you want then ='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5&" "&'[Twinwire Estimating Sheet.xls]Start Sheet'!$D$5 Does it As for the Opening and Shutting of the worksbooks my examples work fine Let Me Know Stew "Warren Easton" wrote: ='[Twinwire Estimating Sheet.xls]Start Sheet'!$C$5:$D$5 Yes I am saving the the workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: Can you give me a copy of the link and are you saving after you enter the path Best Stewart If this helps please click the Yes button. "Warren Easton" wrote: Yes and it works when I first set it up, but if I close the workbooks then re-open them It doesn't change and it looks as if the link breaks down somwhere. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Maybe I am Misunderstanding ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 In one work book will pick out the value in C111 in another work book. If the value in C111 changes then that will be reflected in the original wookbook. Is this what you are after? Best Stew "Warren Easton" wrote: Thanks Stew, My path looks similar, and works the first time I input it, but if I close the workbooks then reopen them they don't change in the destination cell. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "stew" wrote: Dear Warren This is a copy of one link that I use from one work book to another. You will see that you have to give the complete path to cell c111 ='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers Spreadsheet'!C111 Hope this helps You can also do it with an Indirect Function whoever the Second work book has to be open to use that Best Stew "Warren Easton" wrote: Sorry Stew, I should have explained this better, it's in another workbook. -- Regards Warren Excel Novice Addiewell, Scotland. "stew" wrote: like this =Sheet2!B1 "stew" wrote: Dear Warren = then click on tab to sheet that you want to connect to and click on the cell on that sheet then tab out of formula should do it Stew "Warren Easton" wrote: Dear All, I have an excel spreadsheet that has links to two other sheets, I've just typed in = then went to the sheet and clicked on the cell I want to link to. Everytime I open these sheets the links between then turn to source unknown and they don't update on the first sheet. Can anyone advise what I'm doing wrong? -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying Links when opening sheets | Excel Discussion (Misc queries) | |||
| COMBINING LINKS TO DIFFERENT SHEETS | Excel Worksheet Functions | |||
| How to update links between wk sheets | Excel Worksheet Functions | |||
| Links between sheets | Excel Discussion (Misc queries) | |||
| how do i find which sheets contain links? | Excel Worksheet Functions | |||
Linear Mode
