Forum Discussion
Duplicate distinct counts in pivot tables corrupts files
- 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.
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