challa

Perhaps you should take another look at how AutoRecover operates.

Not at all as you describe below.

If you want a backup saved when you save and close the file you must set that up
in FileSave AsToolsGeneral Options "always create a backup".


Gord Dibben MS Excel MVP

On Wed, 4 Jul 2007 02:48:02 -0700, challa prabhu
wrote:

You can use AutoRecover to have Excel automatically save a backup copy each
time you save a workbook. The backup copy provides you with a previously
saved copy, so you have the current saved information in the original
workbook and the information saved prior to that in the backup copy. Each
time you save the workbook, a new backup copy replaces the existing backup
copy. Saving a backup copy can protect your work if you accidentally save
changes that you don't want to keep or delete the original file.