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, am also getting this issue with some sheets with pivots. Any response from Microsoft support from your ticket?
SPO, opening file with Excel for Web and desktop app both give the corrupted file error. Opened in Google sheets, exported it back to xlsx file and it is working fine.
No reply yet, but the ticket is still open.