I am looking for a solution to refresh excel sheet formulas after new values are inserted. We are not allowed to set formula recalculation to automatic.
The solution that I have designed is click on a cell and then sending hot key (shift +f9) to the cell which will refresh the sheet.
The problem now is the how to know the refresh is completed? The number of rows/value in cells before and after refresh might or might not change. Hence checking value is not reliable solution.
I need to perform another operation on the same sheet after refresh is completed.