Restoring Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Stupid Stupid me made some changes to a worksheet and without thinking just
clicked on the save icon. Wanted to save it under a different name. I just
managed to lose a weeks worth of payroll info.

Is there any way to restore the worksheet prior to making changes????????????
 
I'm afraid there isn't but you (your IT dep't) may have a backup or you may
have mailed it to someone.

Mike
 
Hi,

I do understand how frustrating it becomes when you loose vital information
if do not understand tool better at times. Follow these steps next time, to
be careful in all your effort you make.

Automatically save a backup copy of a workbook

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.

1. On the Tools menu, click Options.
2. On the Save tab, select the Save AutoRecover info every check box.
3. In the minutes box, type or select a number to specify the interval for
how often you want to save files.

The more frequently your files are saved, the more information is recovered
if there is a power failure or similar problem while a file is open.

Note AutoRecover is not a replacement for regularly saving your files. If
you choose not to save the recovery file after opening it, the file is
deleted and your unsaved changes are lost. If you save the recovery file, it
replaces the original file (unless you specify a new file name).


Challa Prabhu
 
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 File>Save As>Tools>General Options "always create a backup".


Gord Dibben MS Excel MVP
 
Back
Top