AutoSave is one of the most confusing and frustrating features of Microsoft Excel, primarily because most people don't understand it properly. So I'm writing this post to clarify how it works for future reference.
What is AutoSave?
AutoSave is Microsoft's attempt to replicate the way Google Sheets automatically saves changes in real time, thereby preventing the need to ever Save or Save As.
This is great in theory but not so great when building complex financial models.