XL2000: PivotTable Report Created on New Worksheet Despite Setting in Wizard (213897)
The information in this article applies to:
This article was previously published under Q213897 SYMPTOMS
When you create a new PivotTable report in Microsoft Excel 2000, Excel creates the report in a new worksheet even when you specify an existing worksheet.
CAUSE
This problem occurs when you use the PivotTable and PivotChart Wizard and specify to create the PivotTable report in an existing sheet, but you do not specify the range from which to begin creating the report.
RESOLUTION
To resolve this behavior, in the PivotTable and PivotChart Wizard, supply the range at which to begin creating the PivotTable report.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 9/27/2003 |
|---|
| Keywords: | kbbug kbpending KB213897 |
|---|
|