Hi, new to the forums - 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?
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?
