Getting an error trying to refresh a pivottable with the “Add this data to the Data Model” checkbox selected and with a distinct count.
var worksheet = workBook.Worksheets;
if (worksheet.PivotTables.Count > 0)
foreach (Aspose.Cells.Pivot.PivotTable pivotTable in worksheet.PivotTables)
pivotTable.RefreshDataFlag = true;
pivotTable.RefreshDataFlag = false;
Thanks for the reply. I downloaded the latest version and am still getting an error.
Attached is an example of the type of pivot I’m trying to refresh.
Thanks for looking into this. Can you provide an ETA on when a fix might be in place? We need to determine if this tool is going to be a viable solution for our use case.
Sorry, I have not encountered this error. What does it say? Also, not sure what you mean by a “correct” file. Was the one I submitted corrupted?
I think the requirement is pretty straightforward, can you replicate on your end with a new file? Just create a pivot on two columns of data using the “data model” checkbox I referred to.
STA:can you replicate on your end with a new file? Just create a pivot on two columns of data using the "data model" checkbox I referred to.
Okay thanks. I do not get that error on my side when manually refreshing. Also, the latest version of does not work either.
Attached is another file.
Can you confirm, using my file or your own, whether this issue exists on your end?