Source Data for PivotTable Displayed as Number Signs
Article ID: 177342
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 for Macintosh
- Microsoft Excel 5.0a for Macintosh
- Microsoft Excel 95a
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q177342
SYMPTOMS
After you create a PivotTable, some data in the source range for the
PivotTable may be truncated or the data may be displayed as number signs
(#).
CAUSE
This problem may occur when you place the PivotTable below the source data
for the PivotTable. When you create a PivotTable, the columns containing
the PivotTable are sized automatically to fit the data displayed in the
PivotTable.
The columns contained in a PivotTable will be resized when you perform any
of the following operations:
- You create a PivotTable.
- You Refresh a PivotTable.
- You change the layout of the PivotTable by dragging a field or data
cell.
- You select an item in a Page field.
WORKAROUND
To work around this problem, disable the Autoformat Table option in the
PivotTable Wizard. To do this, follow the steps for your version of
Microsoft Excel.
Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition
To disable the Autoformat Table option, follow these steps:
- Select a cell contained in your PivotTable.
- Click PivotTable Report on the Data menu.
- Click Next to advance to Step 4 of the PivotTable Wizard.
- Click Options. Click to clear the Autoformat Table check box, and then
click OK.
- Click Finish
Microsoft Excel versions 5.0 and 7.0 for Windows, 5.0 for the Macintosh
- Select a cell contained in your PivotTable.
- Click PivotTable on the Data menu.
- Click Next to advance to Step 4 of the PivotTable Wizard.
- Click to clear the Autoformat Table check box, and then click Finish.
REFERENCES
For more information about formatting PivotTables, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Troubleshoot
formatting and changing PivotTables" topic.
Additional query words: XL97 XL
Keywords: kbprb KB177342