ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is filtered in a Pivot Table? Finding out quickly... (https://www.excelbanter.com/excel-discussion-misc-queries/137632-what-filtered-pivot-table-finding-out-quickly.html)

BenS

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.


All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com