i also saved it
is there any way to recover it?
When you save the file and close the workbook, Excel actaully deletes the temp file it created during your edit. So you might have a better chance by running any of the undelete tools. Search for the files with ~ or # in their names.
If the file was saved on a Windows Vista, 7 or server 2003, 2008 system you may well have shadow copy service running and keeping previous versions for you. You can't restore individual files, so you need to:
You can try something like Recuva. It is extremely important that you stop modifying files on your computer and run this ASAP, as it will reduce the chance that the unlinked file will be deleted from your HDD.
If you have deleted and saved it, I fear you will not be able to get this back. Even with memory dumpers, etc.
Cry a little, then move on and learn the lesson. :)
This does point out a usability issue however...
Most programs have an 'Undo' function. Unfortunately, a lot of programs are also limited in what you can undo.
For the example you gave, you can delete cells, rows, and columns then undo it like it never happened. Delete a worksheet however and no dice!
Personally, from a user standpoint, there is no logic reason this should be the case.
Just something to mull over for those writing software with undo functions. If a use can do an action, they are as sure as <<insert something that is a certainty here>> going to want to be able to undo it at some point.
Did you save it to a network drive? Some network drives have nightly backups or even hourly backups. You could recover from one of those backups if available.
You might try DiskInternal's software - Excel Recovery. I've had particular luck using their tools to recover accidentally deleted files and whole partitions in the past. You'll have to pony up some cash to get it to actually save the recovered files, but it'll show you exactly what it was able to find in a preview before making you pay, that way you know if it was able to recover the data.
At this point it boils down to is it worth the cost. Either way, if you plan on potentially using the software, stop using your system immediately - any time a file is saved, there's a chance it'll overwrite the data needed to recover the file.
Since this is an old thread, I would like to add that there's a new feature since I believe Office 2007 - Autosave function. In Office 2010 it is enabled by default and you can find your autosaved docs in user application data (e.g. in Excel you can look see the path in "File - Options - Save") or just look up more info on this link:
http://www.wikihow.com/Enable-AutoRecover-and-AutoSave-in-Microsoft-Office-2010