<p><span style="font-size:11pt;"><span style="font-family:calibri, sans-serif;"><span style="color:rgb(31,73,125);">We have a spreadsheet with pivot ranges. The calculation in the pivot range is not automatically refreshed when the report is exported in XLSX format in iServer.</span></span></span></p>
<p><span style="font-size:11pt;"><span style="font-family:calibri, sans-serif;"><span style="color:rgb(31,73,125);">XLS format works fine. In the attached Excel, look at the pivot range calculation at D39. It shows as Zero. If you collapse the pivot by clicking B27 then the calculation shows up, as 100%</span></span></span></p>
<p> </p>
<p><span style="font-size:11pt;"><span style="font-family:calibri, sans-serif;"><span style="color:rgb(31,73,125);">Is there a setting in iServer that will aloow us configure this.</span></span></span></p>
<p> </p>
<p><span style="font-size:11pt;"><span style="font-family:calibri, sans-serif;"><span style="color:rgb(31,73,125);">Thanks.</span></span></span></p>
<p><span style="font-size:11pt;"><span style="font-family:calibri, sans-serif;"><span style="color:rgb(31,73,125);">Raj</span></span></span></p>
<p> </p>
