Article ID: 110890
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0c
This article was previously published under Q110890
SYMPTOMS
In Microsoft Excel, when you create a PivotTable, or add a column field to an existing PivotTable, you may receive the following error message
and the PivotTable is not created or the column field is not added.
CAUSE
This error message appears when you add too many column fields to the PivotTable. The number of column fields that you can add to a PivotTable varies with the amount of data in the PivotTable and the memory available on your computer.
WORKAROUND
When you create a PivotTable, limit the number of column fields you use to three or four, especially when you create the PivotTable from a large database. When you need to create a PivotTable with a large number of fields, use row fields. Because row fields do not use as much memory as column fields, you will be able to add more row fields to your PivotTable than column fields.
In Microsoft Excel for Windows 95, you may be able to use as many as nine column fields in a PivotTable without receiving the "Not enough memory" error message.
MORE INFORMATION
You can add a row or column field to an existing PivotTable using the shortcut menu by doing the following:
- Select a cell in the PivotTable, and click the right mouse button.
- From the shortcut menu, choose Add Row Field or Add Column Field, and then choose the field you want to add as a row or column field in your PivotTable.
REFERENCES
For an Overview Of Creating A PivotTable, choose the Search button in Help and type:
PivotTables, creating
Additional query words: XL Err Msg
Keywords: KB110890
