Beware the AutoSave If You Are Not Co-Authoring


October 11, 2021 - by Bill Jelen

Beware the AutoSave If You Are Not Co-Authoring

Problem: I frequently open an Excel file and make changes with no intention of saving them.

Strategy: If you save your documents to OneDrive, the new default behavior will have AutoSave turned on by default. This setting is terrible for regular Excellers everywhere. If you only want Excel to save when you are ready to save, then remember to turn this setting to off.

If you are not planning on collaborating, avoid ever letting your file have AutoSave = On
Figure 114. Toggle the AutoSave switch to Off if you are not co-authoring.

Or, go to File, Options, Save and turn this off globally.

The Excel MVPs fought hard to get the checkbox under File, Options, Save, AutoSave OneDrive and SharePoint Online files by default on Excel. If you are rarely collaborating, turn this off.
Figure 115. Make all future workbooks default to AutoSave = Off.

This article is an excerpt from Power Excel With MrExcel

Title photo by Donald Giannatti on Unsplash



Bill Jelen is the author / co-author of:
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.