•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Date Filter Not Working in Pivot
Seems like others have had this issue and I just want to rant. Sometimes the date filter in my PivotTable doesn’t auto group by year/month. My data is confirmed 100% dates. I’ve refreshed the table, I’ve done everything. I am so so so annoyed that it randomly does this constantly with no explanation. I feel like I’ve tried everything. I know this sounds silly but I have some good experience in excel and this ONE thing I can never been able to fix. I just play around until it randomly works again. Any tips?
[link] [comments]
Want to read more?
Check out the full article on the original site