View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jen Jen is offline
external usenet poster
 
Posts: 119
Default fixed links to another workbook

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?