1 min readfrom 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?

submitted by /u/InternationalMud5730
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article