I recently "Cleared Contents" in a VERY IMPORTANT file and then clicked the
save button instead of Save As. Is there any way to get the data I have
cleared? Thank you in advance for everyone's help.

Wollam, I don't think so unless you have a backup, if you have not backed up
the file other places to look for a copy, have you e-mailed it? May be a
copy in your sent items folder, if file was on a network server it probably
makes backups at sometime, check with you IT person, have you gave the file
to someone else that might have a copy of it? Copy on another computer?
Other wise I think it is gone, in the future ALWAYS create backup files of
your work.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"WOLLAM" wrote in message
...
I recently "Cleared Contents" in a VERY IMPORTANT file and then clicked
the
save button instead of Save As. Is there any way to get the data I have
cleared? Thank you in advance for everyone's help.

Wollam,

Unfortunately, Excel clears the undo history when you do a save, so you couldn't undo the
clear contents. I don't know if anyone knows why this is so. I know it's too late for
this, but it's a good idea to do your save-as before you start making changes.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already
top-posted, the thread gets messy. When in Rome.

-----------------------------------------------------------------------
"WOLLAM" wrote in message
...
I recently "Cleared Contents" in a VERY IMPORTANT file and then clicked the
save button instead of Save As. Is there any way to get the data I have
cleared? Thank you in advance for everyone's help.

When a file is deleted it isn't physically deleted and when file is saved it
isn't necessarily over the original. Let me explain. The computer keeps a
record of all the
files on the hard disk. Think of it as an index. If you were to cross out
a line in the index of a book the word or phrase will still be extant in the
body of the book. (The difference with a computer is that the area of the
'lost' file is available for re-use). It is, therefore, possible to recover
'lost' files. As you will appreciate success depends on whether or not the
area on the hard drive has been re-used.

There are a number of software that will do the job. I have used and,
therefore, can recommend 'Get data back' www.runtime.org. It is highly
recommended that the software is installed on and run from another hard disk
(to decrease the possibility of overwriting the 'lost' file).

All this assumes that, at least, the hard disk will spin. It is possible to
recover data from a hard disk that doesn't spin. This is, however, a
specialist (forensic) operation and will be charged accordingly. It
wouldn't do any harm to find someone local who could do this for you and
assess and possibly justify the charge against the cost (time, patience and
money) of re-entering the 'lost' data. Some work on the amount of data
recovered so if you're looking only for one file the charge may not amount
to much (comparatively speaking),

You should, perhaps, also think of getting a backing up system. You may
like to have a look at my web site www.1001solutions.co.uk for more
information.

Regards.

Bill Ridgeway
Computer Solutions

"WOLLAM" wrote in message
...
I recently "Cleared Contents" in a VERY IMPORTANT file and then clicked the
save button instead of Save As. Is there any way to get the data I have
cleared? Thank you in advance for everyone's help.

Thanks to all. Considering the cost I will attempt to re-enter the data.

"WOLLAM" wrote:

I recently "Cleared Contents" in a VERY IMPORTANT file and then clicked the
save button instead of Save As. Is there any way to get the data I have
cleared? Thank you in advance for everyone's help.