Microsoft KB Archive/213894

= XL2000: Source Data for PivotTable Is Displayed As Number Signs =

Article ID: 213894

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

