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!:)
Hi Andrew M
It seems I can't repro. with Excel for Microsoft 365 MSO (Version 2401 Build 16.0.17231.20194) 64-bit
It could be I misunderstood something, didn't use the same Measures... Could you:
- Upload/share a sample where you get the problem
- Mention what exact version of Excel you run
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.
