I have an Excel workbook with a Power Pivot that references a data set on a worksheet. There are also subsequent tables which reference the Power Pivot to display the data. My problem is that I’m not seeing any way to refresh the Power Pivot using Aspose. Further, when I update the data set on the worksheet using Aspose and then try to open the workbook in Excel, I get a message that the file needs to be repaired and connections.bin are removed as part of the repair process. Is there a way for me to force a refresh of the Power Pivot?
Do you get some error when calling Worksheet.RefreshPivotTables() method? Please note, currently, Aspose.Cells does not support to refresh Power pivot tables or refresh query tables with data model. A ticket was already logged with an id “CELLSNET-49449” for it.
Once we will have an update on it, we will let you know.
I can’t even get that far because the Power Pivot is not updated. I was afraid of that not being supported so I’ll have to try some alternatives. Thank you for confirming!