Creating a Pivot Table

Abstract

Even though you’ve likely created many pivot tables in Microsoft Excel, you sometimes encounter problems while setting them up. You may be familiar with creating pivot tables in Excel 2003, but you have upgraded to Excel 2007, and you can’t find all the familiar commands and option settings. After you create a pivot table, perhaps its layout isn’t as flexible as you’d like, or perhaps you have trouble connecting to the data source you want to use. This chapter discusses the issues you can consider as you plan the pivot table, set up the source data, and connect to the source. Other topics include working with data on separate worksheets, and using the PivotTable Field List.