Excel saves backup despite settings

[starl]

Have a workbook that occasionally locks up Excel requiring Excel to be force-closed (lock up is a separate issue, don't worry about it). We've checked the box to Disable AutoRecover for that workbook, yet when Excel is reopened, there is at least 1 copy of the workbook listed in the left sidebar. Opening any of those workbooks causes Excel to lock up again, hence checking the disable box.
Why are recovery workbooks still being made? We don't want to completely disable autorecovery - just for that one workbook.

 

[t0ny84]

The following are a few things that should hopefully help, I have never experienced this exact issue but I have found Excel Workbooks sometimes make changes on their own whilst trying to be "helpful".



Option #1
Create a copy of the workbook and then on this copy turn on Auto Recover and then save \ close Excel and then open and turn it off again.

Option #2
Using the following VBA code should ensure it is always turned off when the document is opened.

Private Sub Workbook_Open()
    ' Turn off AutoRecover for the active workbook
    ThisWorkbook.AutoRecover.Enabled = False
End Sub

Good Luck!

t0ny84