Corrupt Pivot table with multiple data fields

[Martin]

Hi,

I am having issues when creating Pivot Tables with multiple Data Fields. Creating a table with one Data Fields works fine, but as soon as I add another, the pivot table becomes corrupt. Is this not supported? 

I have added three xlsx files in the attached zip. All are created by the same code, the only difference is the number of data fields being added. 

I noticed that when adding more Data Fields manuelly in Excel, a "Values" Column is created. How can this be replicated with Syncfusion? 

Attachment: xlsxs_93183ab5.zip

[Aravazhi Rajendran]

Hi Martin,

We are currently working on reproducing the issue on our end. We will share the details on June 18, 2025

Regards,
Aravazhi Rajendran

[Aravazhi Rajendran]

Hi Martin,

We have reproduced the reported issue on our end and are currently validating it. We will share the validation details on June 20, 2025

Regards,
Aravazhi Rajendran

[Aravazhi Rajendran]

Hi Martin,

We have confirmed the issue “Excel file with Pivot Table becomes corrupted after saving with a trail watermark” as a defect in our product and we will include the fix in weekly release on July 08, 2025.

Please use the below feedback link to track the status of the reported bug.

Excel file with Pivot Table becomes corrupted after saving with a trail watermark in ASP.NET Core | Feedback Portal

Note: If you require a patch for the reported issue in any of our Essential Studio Main or SP release version, then kindly let us know the version, so that we can provide a patch in that version based on our SLA policy.

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.”

Regards,
Aravazhi Rajendran

[Karthika Santhana Krishnan]

Hi Martin,

 

Sorry for the inconvenience.

 

We have included the fix to resolve the issue "Excel file with Pivot Table becomes corrupted after saving with a trail watermark" in our weekly NuGet release version 30.1.39. Kindly upgrade your Syncfusion packages to this new 30.1.39 version and let us know if the issue is resolved.

NuGet Package: NuGet Gallery | Syncfusion.XlsIO.Net.Core 30.1.39

Root cause for this issue:

When resaving an Excel file containing a pivot table with a trial watermark, the file becomes corrupted. This issue occurs because XlsIO does not correctly serialize the hyperlink watermark when a pivot table is present on the worksheet.

 

Regards,

Karthika S.

[A]

The issue still not resolved even in Syncfusion.XlsIO.Net.Core 30.2.4 in Blazor.  I even tried the working example on the GitHub page and the problem still the same.  The pivot table created is corrupted.  I have attached here a sample of the corrupted pivot table using the working example in GitHub - https://github.com/SyncfusionExamples/XlsIO-Examples/tree/master/Pivot%20Table/Create%20Pivot%20Table/.NET/Create%20Pivot%20Table .

Attachment: Sample_Corrupted_Pivot_Table_1fd3536b.xlsx

[Karthika Santhana Krishnan]

Hi Martin,

 

The corruption issue occurs due to recent update of Microsoft Excel.  However, we have created a fix to resolve this corruption issue based on the latest Microsoft Excel update. The fix will be included in our upcoming NuGet release on August 12th, 2025.

 

Regards,

Karthika

[Karthika Santhana Krishnan]

Hi Martin,

 

As the NuGet release has been rescheduled, the fix will be included in the today’s NuGet release.

 

Regards,

Karthika

[Karthika Santhana Krishnan]

Hi Martin,

We have included the fix in our weekly NuGet release version 30.2.5. Kindly upgrade your Syncfusion packages to this new 30.2.5 version and let us know if the issue is resolved.

Regards,

Karthika