I have Excel with multiple sheets. A few cells in the first sheet will get updated once the data are appended to cells in other sheets because the first sheet has formulas that pull data from different sheets. It works as expected when manually updating the data, but if the bot does the same, the first sheet is not getting updated. I need help to understand what is the issue here.
Can someone help me with this if anyone knows or encountered this issue?