XL Err Msg: Not Enough Memory To Display Pivot Table

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, version 7.0

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.

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:

1. Select a cell in the PivotTable, and click the right mouse button.

2. 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