Adding rows of data into existing xlsx file with pivot tables and charts result with unusable file. How to solve?

[rafinewman]

hi,

i have designed am excel file XLSX with a table of data in sheet1 and pivot table , pivot charts and slicer on sheet2
after it works fine. i have deleted the rows of data and save the file with no data. i have configured the objects to refresh with new data when file is opened.
when i open this empty file and paste rows of data to the empty table, all pivot objects are refreshed and i see new data as expected in the pivot tables and charts and slicer and it functions as expected
BUT,
When I use NPOI with .net 4.8 to fill in the rows ( i checked it separately and it worked fine) and the i open the file, i get an error msg from excel that "we found a problem with some content in file.xlsx. do you want to recover?"
if i answer no, the file is closed, when i answer yes, i get a none usable workbook while data exists in the table but slice and pivot table are not usable and sometimes slice even removed.

is it a known problem? can it be solved? maybe NPOI doesn't support such combination?

[phinheiro]

#1293