Method 1Modify the first row so that it does not contain any empty cells.
Method 2Change the range the PivotTable references to a range where the first row does not contain empty cells. To change or to determine the range an existing PivotTable references, do the following:
- Select a cell within the PivotTable.
- On the Data menu, click PivotTable Report (Click PivotTable in Microsoft Excel 5.0 or 7.0).
- Click Back to display the "PivotTable Wizard - Step 2 of 4" dialog box.
- The current range for the PivotTable is displayed. Edit the source data range.
- Click Finish.
Microsoft Excel 97For more information about PivotTables, click the Office Assistant, type "pivottable," click Search, and then click to view "Create a PivotTable."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar.
Microsoft Excel 7.0For more information about changing the source data for a PivotTable, click the Index tab in Microsoft Excel Help, type the following text
Microsoft Excel 5.0"User's Guide," version 5.0, Chapter 24 "Creating a Pivot Table"
For more information about "Changing Source Data for a Pivot Table" in Microsoft Excel 5.0, click the Search button in Help, and type:
Article ID: 141286 - Last Review: May 17, 2017 - Revision: 2