XL2000: Page Field Area Missing After Creating PivotTable (210808)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q210808

SYMPTOMS

The Drop Page Fields Here area appears to be missing after creating a PivotTable report.

CAUSE

This behavior may occur if all of the following conditions are true:
  • You create a new PivotTable using the PivotTable and PivotChart Wizard.

    -and-

  • In step 3 of the wizard, you click Existing worksheet, and select a cell in the top row of the worksheet as the location to create the PivotTable.

WORKAROUND

You can still drop a field name in the Drop Page Fields Here area even though there is no space provided. If you drop a field name above the PivotTable area, even on the column label, the pointer changes to indicate the page field position. The PivotTable report moves down two rows, and the page field appears.

Another workaround to allow for a Drop Page Fields Here area is to select the entire PivotTable report after it is created and drag it down at least two rows. A Drop Page Fields Here area will appear when you drop the PivotTable report in the new location.

MORE INFORMATION

In step 3, the PivotTable and PivotChart Wizard asks for a location to place the PivotTable. Before you started the wizard, if you selected a cell containing data, New worksheet is selected and the PivotTable report automatically begins in cell A1 on a new worksheet.

However, if before you started the wizard, you selected a blank cell in the first row outside the data area, Existing worksheet is selected, and the PivotTable report automatically begins in a cell two rows below the blank selected cell. This effectively provides the space necessary for the Drop Page Field Here zone to appear. In this case, step 2 of the wizard asks you to select the area of data to include in the PivotTable report, because it is not selected automatically.

REFERENCES

For more information about page fields, click Microsoft Excel Help on the Help menu, type Use PivotTable page fields in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbbug kbpending KB210808
©2003 Microsoft Corporation. All rights reserved.