Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
when you link to the source document, only the abosolute reference of the source document is maintained. The references are not relative. So if you make changes in the source document, you must relink to the source document again. Eevn if you copy and paste the data using paste special command. Challa Prabhu "Liege" wrote: When making any changes to your source document how do you get the linked documents to follow any changes. For example, inserting rows and/or moving data to other locations in the source document, when doing this the linked documents do not follow the moves. The linked documents data changes to whatever row/column it was originally linked to. Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
Drawing info from another source document | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
convert existing Excel into Data source document to link to exist. | Excel Discussion (Misc queries) | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) |