Forum Discussion
Excel for MAC Pivot Filters
JenniferD300 That's the way it is! I worked with Excel for Mac for more than 10 years without even knowing that is lacked certain functionality and I never missed it. Now, I use both in parallel and realise that the Windows version has certain features that I can no longer do without. The pivot table filtering is not one of them, as I hadn't even noticed it before.
JenniferD300 As far as I can determine, that feature simply does not exist in Excel for the Mac.
Riny_van_Eekelen - Thank you so much, I did not see it, but what a disappointment that I do not have the full functionality that I do with Microsoft. Do you suggest another avenue for completing what I am attempting? Multiple filters of a list, there has to be a way, can not imagine that MAC would not have another way to complete such a simple task that Microsoft handles with ease.
Thanks again,
Jennifer D
Workaround
Simply copy the pivot table to new sheet & pate as values then apply filter. Now filters will work
JenniferD300 That's the way it is! I worked with Excel for Mac for more than 10 years without even knowing that is lacked certain functionality and I never missed it. Now, I use both in parallel and realise that the Windows version has certain features that I can no longer do without. The pivot table filtering is not one of them, as I hadn't even noticed it before.
Thank you so much Riny_van_Eekelen, wanted to make sure I was just not missing it. Will find another way 🙂
Jennifer D
