Excel's Auto Recover feature can be a real lifesaver after a crash. With Auto Recover enabled, Excel saves a copy of your workbook every 10 minutes (or uses a different interval that you can specify). In the event of an application crash, you can access these Auto Recover files to recover unsaved data.
Unfortunately, whenever you close a workbook intentionally (e.g . under any circumstances other than a complete application crash), all of the Auto Recover files are permanently deleted. If you accidentally clicked "Don't Save" when you really meant "Save," you're up a creek without a paddle.
In XL10+, however, you may be in luck. There's a handy option to keep the last Auto Recover file for just such an occasion, but it's not enabled by default. Do yourself a favour, and go turn it on now:
(1) Go to File | Options (Alt F | T).
(2) On the Save tab, place a tick next to Keep the last autosaved version if I close without saving .
(3) Choose OK.
No comments:
Post a Comment