PivotTableBuilder on older Excel Versions
Author: serconCreated Aug 25, 2026Updated Sep 9, 2026
Hi,
The new PivotTableBuilder when creating .xlsx files works very well when opening in newer Excel versions!
https://phpspreadsheet.readthedocs.io/en/latest/topics/pivot-tables/#creating-a-pivot-table
When opening on older version like eg. Excel 2016, it gives an error 'We found a problem with some content in... Do you want us to revover as much as we can?' Clicking yes, the spreadsheet opens, but the pivottables have been removed. Opening the same file in Excel 365 gives no issues.
Source: PHPOffice/PhpSpreadsheet