I have a very simple issue but can't seem to find a solution.
I have a test worksheet that has 2 cells who's values I set with ".PutValue". I then close the workbook.
I then do some work, reopen the same workbook and sheet to retrieve the value of a 3rd cell that has a formula in it. The formula is dependant on the 2 above values.
When I try to retrieve the calculated value, it returns zero.
Is there a function to call to force the calculation?