View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Venice Venice is offline
external usenet poster
 
Posts: 7
Default Value filter in the pivot table is disables

Hi I created a pivot table containing all the numbers. The filter can only
display the top 10 features, while the rest are filter are grayed off.
So I went to the Pivot Table Options and found that Pivot Table Options
Total & Filters tab also gray off the "Allow multiple filters per field" box.
How can I enable it back? Pls help. Thanks.