Knowledge Base

Not Enough Memory To Display Pivot Table

Article ID: 110890

Article Last Modified on 8/15/2005

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

Not enough memory to completely display PivotTable.

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