I've an excel with formulas, and I've two problems
1. When I insert data in cell, formulas values are not updated
2. When I close de worksheet saving, the worksheet is not saved
I attach an example. In the example, if I set SI value in B2 cell, B9 cell has 100 value, else 500.
So, in the code, I set SI value, but the B9 value is 500 not 100.
Also, if I do workbook.save(true) (Close the workbook and save) B2 cell is empty, but if I save with other filename, B2 has SI value