ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I used "save" instead of "save as" in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/117012-i-used-save-instead-save-excel.html)

Ken Walters

I used "save" instead of "save as" in Excel
 
Is it possible to restore an Excel document if I used SAVE instead of SAVE AS
to create a new document??

Dave Peterson

I used "save" instead of "save as" in Excel
 
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???

Ken Walters wrote:

Is it possible to restore an Excel document if I used SAVE instead of SAVE AS
to create a new document??


--

Dave Peterson

Ken Walters

I used "save" instead of "save as" in Excel
 
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.

Dave Peterson

I used "save" instead of "save as" in Excel
 
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.


--

Dave Peterson

David Biddulph

I used "save" instead of "save as" in Excel
 
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.
--
David Biddulph

"Ken Walters" wrote in message
...
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.




Earl Kiosterud

I used "save" instead of "save as" in Excel
 
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.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Ken Walters" <Ken wrote in message
...
Is it possible to restore an Excel document if I used SAVE instead of SAVE
AS
to create a new document??




Bruce Sinclair

I used "save" instead of "save as" in Excel
 
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.





All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com