Microsoft KB Archive/213897

= XL2000: PivotTable Report Created on New Worksheet Despite Setting in Wizard =

Article ID: 213897

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000

Keywords: kbbug kbpending KB213897

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.