I created a code that inputs data into an excel spreadsheet. For example: I have Sheet1 (which will receive data via code) and Sheet2 (which has dozens of formulas). For illustration, on Sheet1 there is the following sum: =sum(Sheet2B2:A3). The problem lies in the following. Excel only calculates the result after opening the spreadsheet and if I try to import the sum result before opening, saving and closing the spreadsheet the values ​​are null and zero.