Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: PivotTable Report Created on New Worksheet Despite Setting in Wizard

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

View products that this article applies to.

This article was previously published under Q213897

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Resolution

To resolve this behavior, in the PivotTable and PivotChart Wizard, supply the range at which to begin creating the PivotTable report.

↑ Back to the top

Status

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

↑ Back to the top

Keywords: KB213897, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 213897
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 243