I used "save" instead of "save as" in Excel

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

Guest

Is it possible to restore an Excel document if I used SAVE instead of SAVE AS
to create a new document??
 
Only if you have a backup version of that workbook somewhere...

Maybe in your sent folder of your email software???
Maybe someone you shared a copy with can forward an earlier copy back to you.
Maybe your IT folks back up your network drives/local harddrives???
 
I was finished with a monthly report, which I save, but I make changes at the
beginning of each month to alter some of the items in the report and save the
file with the changes as a different document. After deleting all the
previously entered data, and saving under the same document name, I'm afraid
the entire report is lost.
 
I'm afraid you're right and the data is lost.

Ken said:
I was finished with a monthly report, which I save, but I make changes at the
beginning of each month to alter some of the items in the report and save the
file with the changes as a different document. After deleting all the
previously entered data, and saving under the same document name, I'm afraid
the entire report is lost.
Click to expand...
 
I would recommend that in future you choose the "Always create backup copy"
option when you "Save As", and also that the first thing you do when you're
producing the new version is to "Save As" with the new document name before
you forget, and before you change any of the content.
 
Ken,

In the future, set the original file read-only (in the folder window,
right-click the file, select Properties, and check read-only). If that's
not appropriate, do the Save-as before you start making changes. Then save
from time to time, and when you're done with the changes.
 
I'm afraid you're right and the data is lost.
Click to expand...

Suggest you alter your process to avoid this in future.
Open the file.
Save as <new filename>
then make your changes and
save them.

The worst that happens with this method is you accidentally 'save' the
original file over the original file - no damage - or save as your altered
file over your new file name - again, no damage :)

Yes you could still stuff it up ... but this makes it harder.

HTH for the future.
 
Back
Top