Excel Forum
Similar Content
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Me Keyword in Excel Macros & VBA
Tutorial: The Me keyword in Excel VBA allows you to refer to either the current worksheet, workbook,...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...

Excel Magic Trick #182: Workbook References

See how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook. Learn about the syntax used with workbook references. See how to update the workbook reference and how to fix it when the workbook references are broken (Change source file).
The square brackets, [ and ], are what Excel puts around the workbook name. The apostrophes, ' and ', are what Excel puts around the workbook name and worksheet name. The explanation point, !, always comes after the worksheet name.
By default, when you use a workbook reference, the cell reference is absolute (with two dollar signs). You can change it with the F4 key.
When using workbook references save the two files in a permanent location so that the workbook with the workbook reference can be updates if necessary.
To edit Links: 1) in Excel 2003, go to the Edit menu, Links; 2) in Excel 2007, go to the Office Button, Prepare, Edit Links.

Got a Question? Ask it Here in the Forum.