Forum Discussion

Christi Brown's avatar
Christi Brown
Copper Contributor
Oct 24, 2018

Linking workbooks

Hi,

My scenario - I have one workbook (source/original) with information -- A,B,C,D,E,F -- that needs to be shared/linked to a 2nd workbook -- that contains only part of the information -- A,B,C only -- from the original/source workbook. I need the 2nd workbook to update automatically as information is changed in the source workbook -- and vice versa if possible.

excel

3 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 25, 2018
    Links in workbooks are a one-way street: There can only be one source workbook (That'd be your ABCDEF one) and one that pulls data from the source. Writing back to the source can of course be programmed, but why not just edit the source rather than the target?
    • Christi Brown's avatar
      Christi Brown
      Copper Contributor
      Oct 26, 2018

      Thanks for the reply.  So how do I link 2 workbooks so that the source updates to the destination automatically?    

      Also, how do I choose which cells I want the destination to 'see'. I don't want all of the info from the source to go to the destination.

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Oct 29, 2018
        You link directly by using a direct formula, just open both workbooks, activate the destination file and type the equal sign in the correct cell and then point to the other workbook and click the cell from which you want to pull the information and press enter. However, if you don't want to pull in all information but for example want to filter the table first, you'd best use the tools from the Data tab. Which Excel version are you using?

Resources