Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
How do I make links move with a cell.
ie: I have data in one work book linked to another wokbook but whenever lines are added to the source book and the cell containing the data I want moves, the link in the destination workbook does not follow the cell. Can this be fixed or should I be using something other than a link?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
You need to have both files open at the same time when you are inserting
lines the other open the first one gets updated. After you are done adding rows/column save both documents. Next time you open the file it is reflecting the correct/updated changes. "Sharonm" wrote: How do I make links move with a cell. ie: I have data in one work book linked to another wokbook but whenever lines are added to the source book and the cell containing the data I want moves, the link in the destination workbook does not follow the cell. Can this be fixed or should I be using something other than a link?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Links: Re-establishing Links | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |