Hello,
I have created a pivot table using a very large amount of data. When a drop down box is selected in the pivot every option is already ticked. I would like the choice to untick all boxes and then just choose 1 option rather than manually unticking all the boxes.
Does anyone know if this is possible when using Excel 2000?
Thank you
Ginny
I have created a pivot table using a very large amount of data. When a drop down box is selected in the pivot every option is already ticked. I would like the choice to untick all boxes and then just choose 1 option rather than manually unticking all the boxes.
Does anyone know if this is possible when using Excel 2000?
Thank you
Ginny