Microsoft KB Archive/210808

= XL2000: Page Field Area Missing After Creating PivotTable =

Article ID: 210808

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

