Drill Down in PivotTables

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?


"doco" wrote:

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

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 **** me off! hehehe

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


Thanks
doco



"Gregg Riemer" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
> "doco" wrote:
>
>> 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
>>
>>
>>