Forum Discussion

CDunning's avatar
CDunning
Copper Contributor
Jun 21, 2023

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

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.

Resources