Forum Discussion
Formulas Not Calculating in Workbook
Hello, I have a very large workbook with many formulas across different sheets. I currently have this workbook set to manual calculations only. And it is saved in a Sharepoint Directory with autosave...
Tried several things to fix, but nothing worked. What is weird, the formula in the cell was working fine, then stopped working. If I move the cell out of the current view of the worksheet (1) and return it will update. So, I just added the following statements to my macro and it works. Happens so fast you can't tell there was a change.
Sheets("Sheet2").Select
Sheets("Sheet1").Select