O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 you should 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 on page 470 and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required