View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BenS BenS is offline
external usenet poster
 
Posts: 22
Default What is filtered in a Pivot Table? Finding out quickly...

Is there any way to find out what filters have been applied to a pivot table
without double clicking each item and seeing if anything is hidden or not? I
frequently get pivots with large numbers of fields that have been worked on
by others prior to me getting them. It can become a time consuming exercise
to try to find what if anythinng has selections or filters applied.

Thank you.