Forum Discussion
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 onl...
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?
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.
- 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?