Free Support Forum - aspose.com

Pivot Table - Report Filter

Aspose.Cells Product Family
#1

I have created an excel template to use to create a pivot table. I basically just refresh the data when I create the spreadsheet. everything works fine except the report filter drop downs are empty and I can't seem to get them to refresh, even using excel.

Any ideas,

Scott C

#2

Hi,

Which version of Aspose.Cells do you use? Which verison of Ms Excel do you use?

Could you post template file ,created file and sample codes to show this problem?

#3

I'm using Excel 2007 but my template is an excel 97-2003 file. The template is the same. I'm pretty sure this use to work until I upgrade to the new Aspose.Cells just a few weeks ago, version 4.4.0.0.

Attached is a template. thanks for your help

#4

Here is an example of the output. Notice that the report filter dropdowns are both empty.

thanks

#5

Hi,

You are right. It's caused by we try to read combox from the template file recently.

Please try this fix.