View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default source document changes

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!