Chapter 28: Linking and Consolidating Worksheets
28
FIGURE 28.9
Expanding the outline to show more details
For more information on Excel outlines, see Chapter 27, “Creating and Using Worksheet Outlines.”Refreshing a consolidation
When you choose the option to create formulas, the external references in the consoli-
dation workbook are created only for data that exists at the time of the consolidation.
Therefore, if new rows are added to any of the original workbooks, the consolidation must
be redone. Fortunately, the consolidation parameters are stored with the workbook, so it’s a
simple matter to rerun the consolidation if necessary. That’s why specifying complete col-
umns and including extra columns (step 3 in the preceding section) is a good idea.