| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Filter | Excel Discussion (Misc queries) | |||
| Pivot Table vs Filter | Excel Discussion (Misc queries) | |||
| filter on pivot table | Excel Discussion (Misc queries) | |||
| Pivot table and filter | New Users to Excel | |||
| filter & pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
