Hello,

I need to export data from a grid to excel. I did this several times, but this time the template file has a pivot table in the second worksheet. I export data to the first worksheet, and the pivot table should use this data in the second worksheet.

The problem is that the pivot table works fine in the template file, but it seems to have disappeared after the export. The second worksheet is still present and has all the formatting, titles, etc., except the pivot table.

The data export in the first worksheet works fine too.

I use Workbook.Load(templatePath) and Workbook.Save(destinationPath) in Infragistics 2008.3. I can send the files before and after export by PM.

I just can't see why the pivot table disappears during the export.

Thanks,

Thomas.