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...
I have had a similar problem. I struggled to find the solution which is why I am replying here. I found that my Excel version had been updated and I needed an Application.CalculateFullRebuild, or Ctrl + Alt + F9.
https://learn.microsoft.com/en-us/office/vba/api/excel.application.calculatefullrebuild
I hope this helps someone.
