This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Why Aren’t the Cool New Filters Available in My Pivot Table?
Problem: When I try to filter a pivot table, everything except Top 10 is grayed out. What’s the problem?
Figure 852 New filters are greyed out.
Strategy: Your pivot table was created in Excel 2003. If a pivot table was created in a legacy version, then Microsoft is afraid that you will want to open the pivot table again in the legacy version.
If you and everyone else who might open the file is now using Excel 2007, you can delete the pivot table and re-create it in Excel 2007 or 2010. The new filter options will then be available.
<-Previous Topic Next Topic->
For more resources for Microsoft Excel: