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.
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.