Turn Off AutoRecover For Individual Workbooks

In Excel 2007 and 2010, there is a feature called AutoRecover that saves your open workbooks at regular intervals. In the event of a power failure or computer crash or freeze up, this can help you recover your unsaved work. This feature is turned on by default and is hardly noticeable as it happens in the background.

However, you may notice AutoRecover saving files, and may even get annoyed by it, if you have one or more large workbooks open, as it could tie you up for 5 to 10 or more seconds. I often have very large workbooks open that contain only reference information (i.e. files that I'm not making changes to) and other workbooks which I don't require to be saved by the AutoRecover feature.

To avoid the unnecessary saving of these files, there is an option available to turn off AutoRecover for individual workbooks.




Here's how...

1) Click the File tab (2010) or the Office Button (2007);

2) Click Options (2010) or Excel Options (2007);

3) Click the Save option on the left;

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

(adapted from "excel addict")

Comments

  1. I consider that using a participant's card leads to the on line casino operations room technician controlling your total experience, and as said by one contributor, one loses in lengthy run|the lengthy term}. Free spins bonus provides are a very common type of on line casino bonus, and you can find them at many on-line casinos. That way, you understand where search out|to search out} the perfect free spin on line casino bonuses. There’s a lot of Vegas excitement across the Slots of Vegas on line casino web site. Epic on-line on line casino bonuses, over 240 nice on-line on line casino games, and some of the the} least offensive wagering necessities we’ve found. By only putting $/€1, would possibly be} sacrificing as little of your individual money 1xbet as potential.

    ReplyDelete

Post a Comment

Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

Excel Keyboard Shortcuts - Handy during day to day work

Alternative for SUMIF and SUMIFS - Part 2 (SUMPRODUCT)