Forum Discussion
Solved
Duplicate distinct counts in pivot tables corrupts files
Hello! I may have discovered a bug. I have a problem with pivot tables corrupting if I place a column of data into the values section of a pivot table twice and summarize both values as a distinct co...
- Thank you so much, Andrew!:)
Lorenzo , thanks for replying! I'm on Microsoft 365 for Enterprise , Version 2401 Build 17231.20194 64-bit. Almost the same as you, but my version doesn't say 16.0.
Did you save the file, close it, and reopeon? I only get the error upon reopening a file containing a pivot table with those parameters. The act of creating the table and making selections doesn't cause any problems.
I did the following 5 times: Opened my sample > Refreshed the Pivot > Saved ==> No issue
Downloaded your DistinctCountTestSampleData_NoErrors.xlsx. Did the same ==> No issue
- Interesting. Are you able to open DistinctCountTestSampleData_withErrors.xlsx?
Sorry, forgot to mention this. Yes I did but after Excel "repaired" the file there was more Pivot: