Large excel pivot table

Aspose.Cells Product Family
1

Hi

We are busy evaluating cells and have a question :

Is there a limit to the size of pivot tables that the cells product is capable of dealing with ? Are there any issues we should be aware of ?

The pivot table we are thinking of building comes in at about 200 megs.

Thanks
Len

2

Hi Len,

Thanks for considering Aspose.

Well, there is not any significant issue related pivot tables. Aspose.Cells follows the same standard of MS Excel, so if MS Excel allows anything or puts any restriction related pivot tables, Aspose.Cells would work in the similar way.

Kindly try the component to create the pivot tables, if you find any issue, kindly let us know and we will be happy to sort out the things asap.

Thank you.

3

Hi Len,

Please try this fix.

This fix will enhance performance if you use a large data source for pivot table