Pivot table counts inaccurate

[jj14]

Hi, I'm not sure what's going on with this seemingly simple excel pivot table.

This file has about 500 rows (with some date columns - formatted correctly as date). The file is shared across multiple users in a teams channel.
This data is summarized into standard pivot tables (all build on the same cache - created the first pivot table, and then copy/pasted to create the other views)
The pivot tables are fairly straightforward - name of user in rows, date (year/month) in columns, and count of record-ID in values - the different tables just change the date field in the column

See example in image (not actual data).

It has been working fine for the past month or two. One of the users noticed that the numbers didn't look right. As in, the count (values) was inaccurate. I reminded them to refresh, and they had already done that. I then refreshed, and then, double clicked on one of the incorrect values to see the resulting rows, and the sheet that popped up showed the correct number of rows. But the pivot table still showed the wrong number of rows.

I ended up removing the date and value from the pivot table design, and added it back in, and it seems to now be fixed - but I'm concerned that this will happened again unless I figure out the root cause.

Anybody seem this happen before? and if so, any fix?
2022-02-28_09-57-44.png

[Glenn Kennedy]

are you sure all the dates are dates... and nottext that look like a date??

[jj14]

Yeah, positive (one of the first things I checked) Even if it was text, I'd expect the problem to persist even when I removed and re-added the fields into the pivot table. In this case, removing the date from column and count from values and then, adding them back fixed it.