xxx
Contents
Preparing the data .................................................................................... 631
Creating an outline automatically ............................................................... 632
Creating an outline manually ..................................................................... 632
Working with Outlines ........................................................................................ 634
Displaying levels ....................................................................................... 634
Adding data to an outline .......................................................................... 635
Removing an outline ................................................................................. 635
Adjusting the outline symbols .................................................................... 635
Hiding the outline symbols ........................................................................ 636
Chapter 28: Linking and Consolidating Worksheets. . . . . . . . . . . . . . . . . . . . . . . . . . . . 637
Linking Workbooks ............................................................................................ 637
Creating External Reference Formulas .................................................................. 638
Understanding link formula syntax ............................................................ 638
Creating a link formula by pointing ............................................................ 639
Pasting links............................................................................................. 640
Working with External Reference Formulas .......................................................... 640
Creating links to unsaved workbooks .......................................................... 640
Opening a workbook with external reference formulas ................................. 641
Changing the startup prompt ..................................................................... 642
Updating links .......................................................................................... 643
Changing the link source ........................................................................... 643
Severing links ........................................................................................... 643
Avoiding Potential Problems with External Reference Formulas ............................. 644
Renaming or moving a source workbook ...................................................... 644
Using the Save As command ....................................................................... 644
Modifying a source workbook ..................................................................... 644
Using Intermediary links ........................................................................... 646
Consolidating Worksheets ................................................................................... 646
Consolidating worksheets by using formulas ............................................... 647
Consolidating worksheets by using Paste Special ......................................... 648
Consolidating worksheets by using the Consolidate dialog box ..................... 649
Viewing a workbook consolidation example ................................................. 650
Refreshing a consolidation ......................................................................... 653
Learning more about consolidation ............................................................. 654
Chapter 29: Introducing PivotTables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 655
About PivotTables .............................................................................................. 655
A PivotTable example ................................................................................. 656
Data appropriate for a PivotTable ................................................................ 659
Creating a PivotTable Automatically .................................................................... 662
Creating a PivotTable Manually ........................................................................... 663
Specifying the data ................................................................................... 663
Specifying the location for the PivotTable ................................................... 664
Laying out the PivotTable .......................................................................... 664
