Pivot Table drop down boxes - cannot select/deselect

C

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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You must log in or register to reply here.

Similar threads

R
  • Question
Extract Data Based on a Drop Down List - Deselect Option
Replies
1
Views
438
Legacy 143009
L
B
  • Question
Pivot Table question - could be impossible to implement
Replies
0
Views
526
buroh
B
T
  • Question
Pivot Tables and clearing filters/filter cache with multiple tabs
Replies
0
Views
495
TDoug
T
R
  • Question
Nested drop down boxes to choose items in a named range - a better way?
Replies
0
Views
240
RockandGrohl
R
D
  • Question
Slicers/ formulas no longer working
Replies
4
Views
256
dd8
D

Forum statistics

Threads
1,214,915
Messages
6,122,217
Members
449,074
Latest member
cancansova

Share this page

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