The CalculationId in your template file might not be ok. This id denotes that only those Excel versions which are greater than it will do the re-calculations for formulas in the template file on loading. Maybe the file was created by some higher version of MS Excel, or it is also possible that the input was created by some older versions of Aspose.Cells. You may change it by code before saving:
wb.Settings.CalculationId = “0”; //you may either set this value corresponding to the desired version of MS Excel, or just set it as “0” to ensure it can be re-calculated (in any case) by all versions of MS Excel
Furthermore, for old versions of Aspose.Cells, we did reset the WorkbookSettings.ReCalculateOnOpen property as true by default. But it was not consistent with MS Excel’s behavior completely and gave unexpected results for some users. So we changed the default value of this property and do not change it without user’s explicit invocation. With new versions of Aspose.Cells, to let formulas in generated file to be calculated automatically by MS Excel when the file is being opened in it, user may set this property as true. Setting the calculation id as “0” also can get the same effect, but we think it may not be the normal way to tackle it. Instead by specifying the WorkbookSettings.ReCalculateOnOpen property as true should be the preferred solution.
Thanks for your understanding and let us know if you still have the issue after following the proposed solutions.