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 enabled.
See Also
10 financial calculations one should know for managing one's financesUse Excel as your calculatorUsing Excel as Your Financial Calculator | The CCIM InstituteHow to Use Microsoft Excel for AccountingWhen the source data for this workbook is updated. None of the formulas are updating when
1. The Calculate Now button is pressed.
2. The workbook is set back to automatic calculation.
3. When the work book is manually saved and closed.
I have noticed another issue. When I go to File > Options. The Options dialogue never appears.
I am wondering if anyone else have experienced this issue, and if so have been able to successfully troubleshoot the problem?
