How to disable auto recover?
try this:
- kill all your sessions of excel (make sure by eliminating any excel.exe processes in task manager)
- start a new session of excel
- load your workbook
- make your setting
- save your workbook
- close excel
- start a new excel session
- open your workbook
- verify the setting has persisted.