LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying cell links with fixed number in between OverlookingSimpleClue Excel Worksheet Functions 3 March 17th 08 10:00 AM
workbook links Russ Excel Discussion (Misc queries) 1 February 5th 08 06:06 PM
My workbook links are not updating (its 30,000 KB size workbook). rselena Excel Discussion (Misc queries) 1 August 14th 06 09:14 PM
workbook links Pat Excel Discussion (Misc queries) 0 April 6th 06 05:26 PM
drawdown at fixed rate over set period from investment at fixed % jamook New Users to Excel 1 November 28th 05 10:53 PM


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"