I have a excel sheet (xls) with formulas inside and when I update it with tFileExcelWorkbookopen - save, the formula are not recalculating when open the file. All the options are setup to automatic calculation.
Any idea what to do for having the formula calculating after update with the components?
Did you checked the option "Evaluate all formulas" in the tFileExcelWorkbookSave component? And actually Excel calculates all formulas also while opening the file. Can you please describe a bit deeper where is your problem. I got you open a file with formulas and you cannot access the values, correct? I which way you have written the formulas, Excel immediately calculates so called shadow values and these values are what you will get in my components when you have access to such a field.
