Pivot fields calculated as a % of parent row total get broken on saving file
I have a template that has Pivot Tables, where one of the value fields is calculated as a '% of parent row total'. I use OpenPyXL to overwrite the source data sheet for the pivot tables. Upon saving the workbook however, the same field in the output workbook shows up as the raw value but with the % number format and the calculation gets reset to 'No Calculation'.