Linking Workbooks

Creating dynamic links between workbooks using external reference formulas provides a number of advantages. For example, you could break a large, complex company budget model into more manageable departmental models. Then you could link all the departmental workbooks (supporting workbooks) to a master budget workbook (a dependent workbook). In addition to creating more manageable and flexible models, linked workbooks can save recalculation time and memory.

The following sections discuss some special considerations to be aware of when working with workbooks linked by external reference formulas. For more information about external references, see "Creating References to Other Worksheets in the Same Workbook" and "Creating References ...

Get 2007 Microsoft® Office System Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.