How to Divide Excel Pivot Table Data Into Separate Spreadsheets Within the Same File

1. Open Excel 2007 and select a workbook. Select the 'Office' button and click 'Open.' Browse your network and click the file. Select the 'Open' button. The workbook opens.
2. Highlight the data you want included in your pivot table. Select the 'Insert' tab and click 'Pivot Table.' Select 'Pivot Table' again. The Create Pivot Table dialog appears. Click 'OK.' A blank pivot table appears.
3. Add fields to the pivot table by checking field names from the right 'Pivot Table Field List.' Add fields that you want calculated or summarized into the pivot table by checking them. Manually drag the field from the field list to the 'Sum Values' section of the right 'Pivot Table Field List.'
4. Drag one of your fields into the 'Report Filter' section of your right 'Pivot Table Field List.' A filter appears above your data. Select the 'Pivot Table Tools' tab. Click the 'Option' tab. Select the 'Options' button in the Pivot Table group. Select 'Show Report Filter Pages.' Click 'OK.' The report filter pages are inserted as a worksheet in your workbook.