Pivot Table - Report Filter

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

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?

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

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

thanks

Hi,

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

Please try this fix.