Pivot tables corrupted on latest version of macos

[Brettm12345]

Description

I'm getting the following error when trying to open files generated with excelize this includes files generated weeks/months ago which worked prior

Steps to reproduce the issue

1. Create a pivot table using excelize
2. Try to open the file in excel

Describe the results you received

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>Repair Result to </logFileName><summary>Errors were detected in file ''</summary><removedFeatures summary="Following is a list of removed features:"><removedFeature>Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)</removedFeature><removedFeature>Removed Feature: PivotTable report from /xl/pivotTables/pivotTable3.xml part (PivotTable view)</removedFeature><removedFeature>Removed Feature: PivotTable report from /xl/pivotTables/pivotTable2.xml part (PivotTable view)</removedFeature></removedFeatures></recoveryLog>

Describe the results you expected

The pivot tables to work as expected

Go version

1.24.3

Excelize version or commit ID

2.9.1

Environment

Macos 15.5

Validations

• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• The provided reproduction is a minimal reproducible example of the bug.

[Brettm12345]

Issue is also present on excel web viewer albeit the documents work in google docs

[xuri]

Thanks for your issue. Could you follow the issue template and show us a complete, standalone example program or reproducible demo?

[Brettm12345]

Yes here you go

https://github.com/Brettm12345/pivot-table-issue

[xuri]

Thanks for your feedback. This issue has been fixed, please upgrade to the master branch code by go get -u github.com/xuri/excelize/v2@master, and this patch will be released in the next version.