Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ordinary links work like a window, looking in at another workbook. The link
is to the cell regardless of what is in it. Adding rows or columns in the source file which shifts the data around effectively breaks the link because even though the link is still looking at cell B3, the relevant data is now in cell B5. Is there a way to link to the value of the cell so the link would update itself if the linked data gets moved? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying cell links with fixed number in between | Excel Worksheet Functions | |||
workbook links | Excel Discussion (Misc queries) | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
workbook links | Excel Discussion (Misc queries) | |||
drawdown at fixed rate over set period from investment at fixed % | New Users to Excel |