|
|
Featured Tutorial
Featured Macro
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.
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.