Drill Down in PivotTables

  • Thread starter Thread starter doco
  • Start date Start date
D

doco

I have a data table listing various attributes (columns) of sale items
(rows). I have created a pivot table on this array. In the pivot table I
have asked for row data on 'size' and column data on 'category' then data on
average of 'price'. All works fine except when selecting the drop down on
'category' I cannot UNCHECK items in the resulting listbox. This happens
periodically with any PivotTable I make and seems to be no ryme or reason
behind this frustrating fallderall!

Under 'Table Options' the 'Enable Drilldown' checkbox is checked...

Any suggestions as to a configuration I have missed or ??? would be greatly
appreciated.

TIA
doco
 
You can't uncheck a page field, but you should be able to uncheck a column
field.
Are you sure you dragged 'category' to the column area and not the page
area?
 
Yes, I am sure. I am not referring to entries to the page area. I have
done a number of things including completely rebuilding the entire workbook
without success. I simply cannot uncheck any of the checkboxes either on
columns or rows on either the table or any charts created from tables. I
saved the file to a ram drive and took it to my office computer and tried it
there and it works fine; I tried it on my laptop and it doesn't work there
either. Evidently there is something about my home system(s) it doesn't
like and it's really beginning to piss me off! hehehe

Using Office 2000 Premium on Windows XP sp2 on all three systems.


Thanks
doco
 
Back
Top