Created attachment 36052 [details] Example class to reproduce the bug. If a workbook is created as SXSSFWorkbook and than (re)read as XSSFWorkbook a XSSFPivotTable can be created. But if the xlsx file is opened, excel complains about removed/repaired features.
Could you add the stacktrace?
There is no stacktrace. The workbook is updated without any message / failure. The problem is visible if the workbook is opened in excel (and probably in open office) only.
I could not reproduce this with POI 4.0.1 and LibreOffice any more, can you recheck with the latest release and report if it was fixed in the meantime?
Could not reproduce the reported problem and no answer for a long time, thus I am closing this for now, please reopen with more information if this is still a problem for you.