• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Linking Excel Data

So far, all the discussion of moving and copying has referred to content that exists in one or more locations, with no connection between the locations. Copying a section of a worksheet or an entire worksheet to another workbook saves you time and effort, but once the section or sheet is copied, the relationship between the source material and the target location may end (unless formulas are included that create links, as described shortly). If you go back to the source worksheet and change any of the data, the changes are not reflected in the place(s) to which the material was copied.

What if you want to establish a permanent relationship between the source material and the target? What if you need to copy a section of a worksheet to another workbook, and you want changes in the original (source) material to update the target (copied) material as well? To establish such a relationship, you must set up a link between the source and the target. Such a link uses OLE (object linking and embedding), a powerful Windows feature.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint