Hi, we are getting this message “The PivotTable field name is invalid” exception with version 18.2 we are using.
We are facing an issue with aspose cells. We were unable to reproduce the same behavior with sample code hence sending you details. Hope you could figure out and tell us what the issue is.
If you open demo.xlsx (in attached zip file), you will find a sheet called as “Limits Export”. The data in that sheet is added on fly from feed.csv (in attached zip file). Following code is run on the merged workbook. When we tried to replicate the behavior by saving the merged workbook our disk and putting that as input to our sample code, it did not give us that exception. Hence, it looks like the issue only happens when it is done on the fly.
Note: When same feed data is copied into the excel manually and refreshed using excel option manually there is no error / exception thrown by excel hence we think the issue with Aspose DLL which may not be handling a specific scenario.
Workbook _workbook = new Workbook(@“demo.xlsx”);
_workbook.Settings.CreateCalcChain = false;
foreach (var ws in _workbook.Worksheets)
foreach (var pt in ws.PivotTables)
var tmp = pt.RefreshDataFlag;
pt.RefreshDataFlag = true;
pt.RefreshDataFlag = tmp;
catch (Exception e)
Please also refer to attached image files for some more details which may help you to understand the issue.
ExceptionScreenshot.png (13.9 KB)
StackTrace.png (2.6 KB)
IssueInOriginalCode.png (34.2 KB)
NoIssueInSampleCode.png (26.3 KB)
ExcelFiles.zip (164.7 KB)