返回
-
标题
TDP Export corrupts pivot table with grouping. -
说明
When exporting data to an Excel file, if that file has pivot table with a group set to a date field on that pivot table, the file gets corrupted. After export, if trying to open the file, it gives the following error:
"Excel found unreadable content in 'testpivot1.xlsx'. Do you want to recover the contents of this workbook?"
To open/recover the file, Excel removes pivot table. The data is imported correctly but the pivot becomes unusable.