MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: AutoSave is Necessary, But Turn it Off When Not Co-Authoring

February 24, 2020 - by Bill Jelen

AutoSave is Necessary, But Turn it Off When Not Co-Authoring. Photo Credit: Frank Okay at

The reason that co-authoring is possible is because of AutoSave. Every time that you make a spreadsheet change, that change will be saved to OneDrive so that others can (almost) instantly see what you just typed. AutoSave is necessary if you want ten accountants editing a budget worksheet at the same time.

But let's talk about workbooks that will never be used with co-authoring. These are the run-of-the-mill workbooks that I use 99.9% of the time. I do not want AutoSave to be active for those workbooks. I want to open Excel, know that I can do some "what-if" changes and then close the workbook without saving. If AutoSave is on, those changes are automatically saved. It is terrible.

Or - you likely recognize the scenario: You have a report for January. You need a report for February. You open the January report, change the headings, and then do File, Save As to save for February. This workflow has been fine for decades. But if you allow AutoSave to be on, you will be destroying the January report as soon as you edit A1 and type February over January.

continue reading »

More Reading

Excel Simultaneously Edit the Same Workbook in Office 365. Photo Credit: Perry Grone at

Excel 2020: Simultaneously Edit the Same Workbook in Office 365 »

February 20, 2020 - by Bill Jelen

After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The feature was released to Office 365 customers in the summer of 2017.

Excel Recover Unsaved Workbooks. Photo Credit: Gary Chan at

Excel 2020: Recover Unsaved Workbooks »

February 19, 2020 - by Bill Jelen

The Auto Recover feature is a lifesaver. It is turned on automatically in Excel 2010 and newer.

read more articles »

Supercharge your career with training from MrExcel

Featured Products

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »

Learn Power BI Dashboarding Techniques by Watching A Pro!

Excel Dynamic Arrays Straight to the Point

Excel Dynamic Arrays Straight to the Point »

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.

Cleaning Excel Data With Power Query Straight To The Point

Cleaning Excel Data With Power Query Straight To The Point »

This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.

Microsoft Excel 2019 Pivot Table Data Crunching

Microsoft Excel 2019 Pivot Table Data Crunching »

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.

Introduction to Financial Modelling

Introduction to Financial Modelling »

With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.

Excel 2019 Business Basics & Beyond

Excel 2019 Business Basics & Beyond »

Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.

see more products »