We have a 2003 template file. We save it in Excel 97-2003 compatible mode after writing some data in it.
We are have some formulae in the sheet (in the template workbook) and don't need it to be invloked automatically. Hence we are using following line of code to avoid that.
exlSheet.Settings.CalcMode = CalcModeType.Manual;
When we open the output workbook in excel 2003 the settings are intact however when we open it in excel 2007 the settings are set to automatic. How to force the settings to be intact in all the excel versions?
Is there any thing we are missing here?