XL2000: Source Data for PivotTable Is Displayed As Number Signs

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 (#).

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.

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.

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.