The data is somehow corrupted when opening a .xlsb extension file that has a Pivot Table in Calc. The Pivot Table becomes values in the spreadsheet and all data underlying is gone.
Is this already a known bug or am I missing something?
Let’s check together.
After opening .xlsb document in Calc, I can update the pivot table.
Could you upload the “wrong document”? Before uploading, change the .xlsb extension to whatever the forum engine “allows”.
Thanks, I will try to figure it out here.
The document has sensitive data. I tried to recreate a dummy file with similar data size, but the error did not occur. 