XL2000: Source Data for PivotTable Is Displayed As Number Signs (213894)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q213894

SYMPTOMS

After you create a PivotTable report, some data in the source range for the report may be truncated or the data may be displayed as number signs (#).

CAUSE

This behavior can occur when you place the PivotTable report below the source data. When you create a PivotTable report, the columns containing the PivotTable data are sized automatically to fit the data.

The columns contained in a PivotTable are resized when you perform any of the following operations:
  • You create a PivotTable report.
  • You refresh a PivotTable report.
  • You change the layout of the PivotTable report by dragging a field or data cell.
  • You select an item in a page field.

WORKAROUND

To work around this issue, disable the Autoformat Table option in the PivotTable and PivotChart Wizard. To do this, follow these steps:
  1. Select a cell contained in your PivotTable report.
  2. Click PivotTable and PivotChart Report on the Data menu.
  3. Click Next twice to advance to step 3 of the PivotTable and PivotChart Wizard.
  4. Click Options. In the PivotTable Options dialog box, click to clear the Autoformat Table check box, and then click OK.
  5. Click Finish.

REFERENCES

For more information about formatting PivotTables, click Microsoft Excel Help on the Help menu, type format a pivottable report in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB213894
©2003 Microsoft Corporation. All rights reserved.