We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

PivotTable External Source

The current version of Aspose.Cells doesn’t support PivotTable that refer to external data sources.

We need to generate a PivotTable connected to an Analysis Services Cube.

The following post : <a href="
says “Related external data sources feature, we will update you soon.”.

Is this feature planned? Will it be a major upgrade?

Also, is it a known issue that Aspose.Cells doesn’t load existing pivot tables in the object model when opening an existing XLS file? I create an Excel file containing a pivot table then load it using Aspose.Cells : oWorksheet.PivotTables.Count is always zero …

Best regards,


This message was posted using Page2Forum from Comparison with Other Solutions - Aspose.Cells for .NET and Java


Thanks for using Aspose.Cells for .NET.

We have done major enhancements in our PivotTable/PivotCharts implementation since then.

We recommend you to please download and try out latest version:

Aspose.Cells for .NET 7.3.3

and it should meet your needs.

You can use the following PivotTable methods/properties in your application.

  1. pivotTable.DataSource
  2. pivotTable.RefreshData()
  3. pivotTable.CalculateData()
  4. pivotTable.ChangeDataSource()

Please also see the following documentation articles relating to PivotTables for your general help.