Thanks for your posting and using Aspose.Cells.
We have tested your issue with your sample excel file and sample code using the latest version: Aspose.Cells for Java v188.8.131.52
and found it is working fine. Please try the latest version and let us know your feedback.
Please also try adding the following line after refresh and calculate data i.e pt.setRefreshDataOnOpeningFile(true). It should also fix your issue.
Thanks for using Aspose.Cells.
We can’t support refreshing the PivotTable with Percentage data formats
for now. We set the “RefreshDataOnOpeningFile” flag to true and let
MS-Excel refresh the PivotTable automatically when opening the result
file. We will support it later.
The issues you have found earlier (filed as CELLSJAVA-41887) have been fixed in this update.