We have a function that has worked for years where we create multiple charts in excel and then save the file.
We also grab the charts as images and paste into word and then convert to PDF. The PDF has the charts, the word doc has the charts but when we open the excel file it gives an error:
"Excel cannot open <workbook name> because some content is unreadable. Do you want to open and repair this workbook?"
When i click yes all the charts are gone. The data to create them is all there.
We are on the latest version of Spire.
The charts create ok as they are in Word and PDF so must be the save.
I have tried
wb.SaveToFile(filename), SaveToFile(filename, ExcelVersion2013) and SaveToFile(filename, FileFormat.Excel2013) but none work
Any ideas as we need this urgently