pivot table - show items with no data
 

Hi - hope someone can help.

I have a problem with the "show items with no data" feature.

For example, I have an excel workbook that is about 4 MB. It has one
worksheet, and on it is one pivot table displaying data from an external
source (via MS Query). The pivot has 7 row fields, no page fields, and one
column field. When I check the "show items with no data" checkbox (for any of
those fields) Excel displays a message "There is not enough memory
available..." When I uncheck the "show items with no data checkbox on that
field, the pivot functions perfectly. The pivot when fully "expanded"
requires only 10,000 rows to display.

This issue w/ the "show items with no data" isn't limited to just one
workbook. This problem occurs on many pivots in many different workbooks.

Anyone have any idea why this is happening?

Thanks so much,
gt