Pivot Table drop down boxes - cannot select/deselect

clarkebruce

New Member
Joined
Oct 1, 2006
Messages
1
Hi, I have a user who has created a Pivot Table but is unable to select/deselect filters from the drop down boxes. The filters appear and are not grayed out, however you cannot click on the ticks to deselect. The user has sent the same file to me and I am able to select/deselect filters on my PC.

We are both on Excel 2000 9.0 and Windows 2000 Professional.

The user has some add-in modules installed that are not installed on my PC. We have played around with these but none of the options appear relevant.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,137,200
Messages
5,680,125
Members
419,884
Latest member
james888sa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top