ExcelBanter - View Single Post - I used "save" instead of "save as" in Excel

Bruce Sinclair

In article , wrote:
I'm afraid you're right and the data is lost.

Ken Walters wrote:

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.

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.