AutoSave with OneDrive

Older versions of Excel used to have a built-in AutoSave command that would periodically backup Excel workbooks. This feature fell by the wayside in the massive overhaul with Excel 2007. Fortunately, AutoSave is back for documents saved to Microsoft’s OneDrive and SharePoint Online services. If you have a Microsoft 365 subscription, then you already have a OneDrive account. Beyond that, anyone can get 5 GB of free storage by simply creating a free Microsoft account. If you need more space, home users can buy 100 GB of storage for $19.99/year, while OneDrive for Business starts at $5/user/month. Learn more or subscribe at www.onedrive.com.

Typically, files that you save to OneDrive are saved every few seconds, which means that it is much harder to lose your work. As shown in Figure 2.6, you can toggle AutoSave on or off on a workbook-by-workbook basis by way of the slider in the Quick Access Toolbar:

Figure 2.6 – The AutoSave...