07-27-2021, 05:14 PM
There's some terminology to clear up and this article might shed some light: https://support.microsoft.com/en-us/offi...038402ff02
In a nutshell, that's correct. There's no "AutoSave" in standalone Excel. AutoSave is a cloud feature for 365 users (i.e. it will only AutoSave to the cloud, not your computer's local drive), and it still needs to be enabled on a document basis (there's a toggle switch for it in the top bar of the document).
What you do have is "AutoRecover" which saves temp files in the event of a crash or unexpected shutdown, however, these files are deleted every time you save (and were likely also deleted when you chose not to save, since that was still a controlled closing of the application).
In a nutshell, that's correct. There's no "AutoSave" in standalone Excel. AutoSave is a cloud feature for 365 users (i.e. it will only AutoSave to the cloud, not your computer's local drive), and it still needs to be enabled on a document basis (there's a toggle switch for it in the top bar of the document).
What you do have is "AutoRecover" which saves temp files in the event of a crash or unexpected shutdown, however, these files are deleted every time you save (and were likely also deleted when you chose not to save, since that was still a controlled closing of the application).