boernecheryl
New Member
I'm using Excel 2007. My pivot table will not let me use the value filters. Anyway to fix this? My database is 21 columns by 39,078 rows (in case that matters). I just want to be able to filter out zero values. It won't let me. All filter options are grayed out except "Top 10".