Assistance in permanently disabling auto-recalculation in Office 365 Excel.

Copper Contributor

We are currently rolling out O365 within our organization. Some of our users that have been migrated have use cases that require data to not be auto refreshed when opening an excel sheet. We have determined a workaround in which users can open a blank workbook, set their calculation options to manual, and can then open the desired workbook without it auto-calculating. My question exists as to whether or not there is a way to simply disable Excel from automatically refreshing the data in a way that persists through various workbooks, and persists throughout the machine being restarted or shut down?

Thank you for your time.

1 Reply


According to this article  the issue should have been resolved in Excel 365.