oops, can you get back a "save as"?

[-Alby Hewlet]

Hi,
I was asked to help out with a clerical error that lost an excel
spreadsheet. What happened was, she accidentally performed a "save as"
after deleting a lot of data in preparation for a new version of the sheet.
So now it's either find it somehow, or re-enter the data.

Is there a way to undo a save as?

TIA

 

[Don Guillett]

if you had a workbook named tt.xls and you used save as to save as ff.xls
then tt.xls is STILL THERE.

 

[-Alby Hewlet]

another oops, it was the other way around. She hit the save when she was
aiming at the "save as." Sorry for getting it wrong here.

the original spreadsheet was opened, the data was manipulated and a lot of
it deleted to create a new template, then she hit the save instead of the
"save as" to put the new template in the working folder.

So, is there away to get the original back?

Alby

 

[RagDyer]

Just open up one of your backups from last week.

You do have one ... don't you?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

another oops, it was the other way around. She hit the save when she was
aiming at the "save as." Sorry for getting it wrong here.

the original spreadsheet was opened, the data was manipulated and a lot of
it deleted to create a new template, then she hit the save instead of the
"save as" to put the new template in the working folder.

So, is there away to get the original back?

Alby

 

[-Alby Hewlet]

yeah, mine are backed up, but this isn't mine. It's a
business spreadsheet that the owner called me to see
if I could retreive it.

In the absence of a back up, is there a way to undo
a save as?

 

[Ken Wright]

Not unless you're prepared to look at third-party utilities that will involve a
charge for this kind of software, and even then it is not guranteed by any
means.

The following is from a post that I copied for my own purposes, but I haven't
tried it at all, so I don't know if it will cater for what you want here, but
you may want to look at it. Some vendors offer demos or time limited trials so
may well be worth exploring:-


Inspector:

http://www.pcinspector.de/smart_media_recovery/uk/welcome.htm

I was able to browse via Explorer type menu for items to be recovered. I could
search for deleted *.dbx Outlook Express files for example and recover them to
an archive area.

PC Inspector uses advanced techniques for recovery even digital media.

They state:

"PC Inspector™ Smart Recovery

is, at present, the only data recovery program for Flash Card™, Smart Media™,
SONY Memory Stick™, IBM™ Micro Drive, Multimedia Card, Secure Digital Card or
any other data carrier for digital cameras..

If you have unintentionally deleted or formatted pictures, videos or sound files
on your data carrier or have pulled it out during a write operation, no matter -
PC Inspector™ Smart Recovery can easily, quickly and absolutely reliably
reconstruct the lost data.

Using the software is child's play. PC Inspector™ Smart Recovery runs on all Win
9x, ME, NT 4.0, XP and Windows™ 2000 systems. To read out the data on the
carrier, you require an appropriate card reader**. "

 

[Bruce Sinclair]

another oops, it was the other way around. She hit the save when she was
aiming at the "save as." Sorry for getting it wrong here.

the original spreadsheet was opened, the data was manipulated and a lot of
it deleted to create a new template, then she hit the save instead of the
"save as" to put the new template in the working folder.

So, is there away to get the original back?

Not easily.

Note for the future :
1) open file
2) save as <newname>
3) do whatever you like to it

Usually only takes doing it wrong once to work this out


Bruce


-----------------------------------------------------------------------
It was so much easier to blame it on Them. It was bleakly depressing to
think that They were Us. If it was Them, then nothing was anyone´s fault.
If it was Us, what did that make Me ? After all, I´m one of Us. I must be.
I´ve certainly never thought of myself as one of Them. No-one ever thinks
of themselves as one of Them. We´re always one of Us. It´s Them that do
the bad things. <=> Terry Pratchett. Jingo.

Caution ===== followups may have been changed to relevant groups
(if there were any)

 

[-Alby Hewlet]

Thanks Ken, that's what I was afraid of. Thanks also for the link to the
software. I'll try it next time I'm over the office and report back here on
how I made out.

 

[Ken Wright]

No problem - Only upside is that when people learn the hard way the lesson is
usually indelibly printed on their memory