"Value Filter" in Pivot Table not available (Greyed out)

**nighttrain** · 02-07-2022, 03:48 AM

I have a simple pivot table which I'm trying to use "value filter" under column heading "Days" - but when choose this function from drop-down list only available one is "Top 10"
I have another file in almost same layout of raw data dump and can use the function without any problem. Not sure why it cannot be used on this one

Thanks

**rorya** · 02-07-2022, 04:47 AM

Save the workbook in xlsx format and reopen it. The other filters weren't available pre 2007.

"Value Filter" in Pivot Table not available (Greyed out)

LinkBack

Thread Tools

Rate This Thread

Display

"Value Filter" in Pivot Table not available (Greyed out)

Re: "Value Filter" in Pivot Table not available (Greyed out)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need assistance with "Pivot Table", "Slicer", and "Dynamic/Interactive Graph"

[SOLVED] Need assistance with "Pivot Table", "Slicer", and "Dynamic/Interactive Graph"

Pivot table - "show items with no data" greyed out

[SOLVED] Filter Pivot Table with a fixed value called "TOTAL" in Pivot Field Name

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

Filter report in pivot table with "greater than" and "less than"

"Clear" button Data Filter section greyed out when sheet is protected.

Bookmarks

Bookmarks

Posting Permissions