Multiple Pivot Table in one workbook

Aspose.Cells Product Family
1

We are generating a workbook which will contain two worksheets, and each worksheet contains one pivot table, and each based on the data in corresponding worksheet. However, we found that in the generated excel report, both pivot tables are using first worksheet's data, we are not able to set the second pivot table to work with second worksheet's data.

Cheers,
Yingbiao

2

Hi Yingbiao,

Thanks for sharing your experience,

Yes, we found the problem with setting data sources with multiple pivot tables in a spreadsheet. We will fix this issue soon.

Thank you.

3

Hi，

Please try this fix.

4

Hi,

Thank you very much for your quick reply, I will try the fix and let you know the result.

Cheers,
Yingbiao