Click here to get my tips every week
Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 21, 2017

Greetings from The Excel Addict

Hi fellow Excel Addict,

In today's 'Excel in Seconds' tip, I'm going to show you how to 'Turn Off AutoRecover For Individual Workbooks'.

If you missed my last 'Excel in Minutes' tip, 'Ensure Data Entered Is The Correct Length', you can read it here now.

Please feel free to share my newsletter with your Excel friends — they will thank you for it.

Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
fhayes[AT] Quote of the Day

"If you can't figure out your purpose, figure out your passion.
For your passion will lead you right into your purpose."

-- T. D. Jakes --

If you missed my last newsletter, you can click here to view it online.

Excel in Seconds with

Turn Off AutoRecover For Individual Workbooks

In Excel there is a feature called AutoRecover that saves a copy of your open workbooks at regular intervals. This feature is turned on by default and is hardly noticeable as it happens in the background. In the event of a power failure or computer crash or freeze up, this can help you recover your unsaved work. I love this feature because, in the past, it has saved me more than once when my computer was misbehaving. It has likely done the same for you.

If you routinely have one or more very large workbooks open, you may actually notice AutoRecover saving these files. This process could tie you up for 5 to 10 or more seconds each time. If any of  the workbooks being auto saved are large files that you have open for reference only (i.e. files that you're not making changes to) or other workbooks which don't need to be saved by the AutoRecover feature, this can get quite annoying.

To avoid the unnecessary backing up of these workbooks, there is an option available that allows you to turn off AutoRecover for individual workbooks.

Here's how...

1) Activate the workbook you want to disable AutoSave for;

2) From the File tab click Options;

3) Click the Save tab on the left of the Excel Options dialog;

4) In the 'AutoRecover exceptions for' section, check the 'Disable AutoRecover for this workbook only' option.

AutoRecover will continue to work as usual but will skip any workbook you specify.

NOTE: After selecting 
the 'Disable AutoRecover for this workbook only' option, you must save your changes (File, Save). After that, every time this workbook opens, AutoRecover will be disabled for that workbook until you enable it and save your changes.

Disable Autorecover For Individual Workbook in Microsoft Excel 2007 2010 2013 2016 365

If you've found this tip helpful, please share it...

Click here to get my tips every week

Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630