I am trying to clear filters in pivot table so I can create multiple pages, but the clear filters option is brayed out and won't allow me to select it. I've tried to change on the ribbon and within the pivot table. note: there are no filtered columns in my data.
Can anyone help?
Bookmarks