Pivot Table lost after saving

[Nitin Gupta]

Hello,

I am opening an Excel file (through ExcelRW) which contains data on one sheet, and a Pivot table on the other. After updating the data, I save the file as a new Excel file. When I open the file, the Pivot Table is no longer a dynamic pivot table, but rather, just the contents of what was in the previous table.

Please note that this isn''t a problem of the Pivot Table not "refreshing", I understand that the user will have to "Refresh Data", however, they can''t even select that option. There is no longer a Pivot Table "object" on that sheet, there is just some data.

Any suggestions?

Thanks,
Nitin

[Administrator]

Hi Nitin,

This is a shortcoming of the current version and we are currently working on adding support for preserving pivot tables in template excel files. It would be another 4 weeks before this feature becomes available. Sorry for the inconvenience.

Thanks,

Stephen.

[nirav desai]

Hi Stephen,

Can you please let me know in which version of Syncfusion ExcelRW, Pivot Excel feature will be available?

Thanks,
Nirav

>Hi Nitin,
>
>This is a shortcoming of the current version and we are currently working on adding support for preserving pivot tables in template excel files. It would be another 4 weeks before this feature becomes available. Sorry for the inconvenience.
>
>Thanks,
>
>Stephen.

[Administrator]

Hi Nirav,

The implementation to preserve Pivot tables in template files is almost complete and should be available in a patch release within 2 weeks time.

Thanks,

Stephen.

>Hi Stephen,
>
>Can you please let me know in which version of Syncfusion ExcelRW, Pivot Excel feature will be available?
>
>Thanks,
>Nirav
>
>>Hi Nitin,
>>
>>This is a shortcoming of the current version and we are currently working on adding support for preserving pivot tables in template excel files. It would be another 4 weeks before this feature becomes available. Sorry for the inconvenience.
>>
>>Thanks,
>>
>>Stephen.