There seems to be a big difference between how an opened Workbook recognizes a pivot tables’ data range.
in version 188.8.131.52 - a pivot range of e.g. MAIN_TABLE in an existing excel file stays stays as MAIN_TABLE when the Workbook is opened.
in version 184.108.40.206 - a pivot range of e.g. MAIN_TABLE in an existing excel file stays changes to the data source’s range so MAIN_TABLE becomes Sheet1!$A$1:$K$700. It took a while for us to find this problem as we have have put aside work on pivot tables since it was working well with pivot ranges equal to the source table’s name.
This is causing a need for a big change in how our application refreshes dynamic source tables.
Could someone suggest a work around for this please? if the range stays as e.g. Sheet1!$A$1:$K$700 then we can no longer work with dynamic tables (That is a big drawback).
I have attached a small project, please try Aspose.Cells v220.127.116.11 and v18.104.22.168 separately, opening the same excel file (testFile3.xlsx). if you look at the Data Source of the pivot table in “sheet1” opn debug mode, you’ll see what I mean.