Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show only relevant no-data items in pivot table | Excel Discussion (Misc queries) | |||
Show Pivot Table Items That Have No Data | Excel Discussion (Misc queries) | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |