Pivot table: Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.

Hi,

i was trying to create an example with pivot tables and i've used your template tPivot1.xlsx
When trying to open the generated excel file with Office 2016 and 2019, i'm getting the following error:

"Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Removed Part: /xl/pivotTables/pivotTable.xml part with XML error. (PivotTable view) HRESULT 0x8000ffff Line 1, column 0."

I thought i was doing something wrong until i opened the same file with LibreOffice and i saw that the pivot table was correctly generated.

Am i missing something or is there really an issue with Office?

Thank you

Start by reproducing the issue with the tPivot1.xlsx template and a generated file, opening it in Office 2016 or 2019 and checking the reported /xl/pivotTables/pivotTable.xml error. Compare the result with LibreOffice; done means the generated workbook opens in the affected Office versions without repair or discarded pivot-table parts.

Written by the indexing model from the issue text.