Pivot Table Filter Drop Down not working
 

I use pivot tables all the time. Suddenly, the check boxes are not responding
when trying to filter results. I've restarted excel several times to no
avail. I tried several files, but all had the same issue.

Pivot Table Filter Drop Down not working
 

Have you refreshed the pivot table? Are those items in the current data?

Jim wrote:
I use pivot tables all the time. Suddenly, the check boxes are not responding
when trying to filter results. I've restarted excel several times to no
avail. I tried several files, but all had the same issue.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Filter Drop Down not working
 

yes I have refreshed the data and the items are part of the current data.

"Debra Dalgleish" wrote:

Have you refreshed the pivot table? Are those items in the current data?

Jim wrote:
I use pivot tables all the time. Suddenly, the check boxes are not responding
when trying to filter results. I've restarted excel several times to no
avail. I tried several files, but all had the same issue.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Filter Drop Down not working
 

What version of Excel are you using?
Is the source data in Excel, or external?
Do the check boxes clear, but those items stay visible in the pivot table?

Jim wrote:
yes I have refreshed the data and the items are part of the current data.

"Debra Dalgleish" wrote:


Have you refreshed the pivot table? Are those items in the current data?

Jim wrote:

I use pivot tables all the time. Suddenly, the check boxes are not responding
when trying to filter results. I've restarted excel several times to no
avail. I tried several files, but all had the same issue.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Filter Drop Down not working
 

2000 SP3
Source data is in Excel
Check boxes will not clear and data stays

"Debra Dalgleish" wrote:

What version of Excel are you using?
Is the source data in Excel, or external?
Do the check boxes clear, but those items stay visible in the pivot table?

Jim wrote:
yes I have refreshed the data and the items are part of the current data.

"Debra Dalgleish" wrote:


Have you refreshed the pivot table? Are those items in the current data?

Jim wrote:

I use pivot tables all the time. Suddenly, the check boxes are not responding
when trying to filter results. I've restarted excel several times to no
avail. I tried several files, but all had the same issue.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html