hi, my application uses template files that have several sheets with pre-configured pivot tables+charts which link to tables. if i remove a sheet that has a table which is linked to a pivot table and the sheet with the pivot table i get a warning when opening in excel because the PivotCache is still referenced in the XML even though the sheets/tables are gone. i have attached a sample template and code to reproduce.
Workbook wb = new Workbook(templatePath);wb.Worksheets.RemoveAt(0);wb.Worksheets.RemoveAt(0);wb.Save(
templatePath + “.out.xlsx”);