Paul McManus
New Member
hi there
i'm trying to filter dates in excel 2016 on PC via a pivot table.
it won't let me filter label on "greater than 1/1/2017" even though i have ensured the cells have proper formatting.
https://support.office.com/en-us/ar...t-report-571cc416-ba4d-4005-a01e-3d99306ccefc
I take it from this article that a power pivot plug in is required, which i tried to install but didn't happen. can anyone suggest a work around?
my mac excel (excel for mac 2011) filtered this pivot table fine... Weird and annoying they'd strip this necessary function out in a newer version.
i'm trying to filter dates in excel 2016 on PC via a pivot table.
it won't let me filter label on "greater than 1/1/2017" even though i have ensured the cells have proper formatting.
https://support.office.com/en-us/ar...t-report-571cc416-ba4d-4005-a01e-3d99306ccefc
I take it from this article that a power pivot plug in is required, which i tried to install but didn't happen. can anyone suggest a work around?
my mac excel (excel for mac 2011) filtered this pivot table fine... Weird and annoying they'd strip this necessary function out in a newer version.