February 21, 2017
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)
If you missed my last newsletter, you can click here to view it online.
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.
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.
If you've found this tip helpful, please share it...
| 'Spreadsheets Tips
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