- Code: Select all
='D:\My Documents\PathName\[WorkbookName.xls]Worksheet Name'!$B$4
This formula consists of not less than five parts: Drive, Path, Workbook, Worksheet and Cell.
Follow these steps for easily creating it:
1. Open the 'Source' workbook from which you wish to import data.
2. In the 'Target' workbook type an equal sign in the cell where you want the data to appear.
3. Switch to the 'Source' workbook and click on the cell whose data you want to import.
4. Enter
Excel will now have placed a part of the above formula in the 'Target' cell, like this:
- Code: Select all
[WorkbookName.xls]Worksheet Name'!$B$4
5. Now close the 'Source' workbook.
Excel will automatically add the drive and path to the formula in each linked cell. Be sure to save this change in your workbook, because if you don't Excel will not know how to find the Link on next use unless the other workbook is open.
In the Edit / Links dialog box you can set how you want the Link to behave. You can make the Link update automatically whenever you open the workbook. Or you can press the 'Break Link' button to replace the linking formula with the imported data. You can open the linked 'Source' workbook from here, change its location or update the imported values at any time.