Hi All, I use Excel to save daily energy data to a spreadsheet that has about 25 columns. This morning I had updated the file and saved the update. I then deleted all but 8 columns as I wanted to do some analysis on these columns. When I went to save the file as a different name so that I did not lose the other data, I accidentally hit "Save" instead of "Save As".
Is there any way to recover the previously saved copy of the file?
Thanks for any help!
Paul
Last edited by VBA Noob; 02-27-2009 at 03:53 AM.
Your only chance is to no save another thing to that disk, and buy some file recovery software.
When Excel (and most other programs) save a file, they write to a new file, verify the save, delete the original (actually, just delete the name from the directory and return the space to the available pool) and then rename the new file. So the original is still there until it really is written over.
It's going to be a PITA, so I wouldn't bother unless it was really, really important.
Entia non sunt multiplicanda sine necessitate
just to add to shg. with recovery software it's still there ,somewhere!.BUT if you do a save on anything at all it might over write that location.So bye bye old file.You never know if it over writes or creates new,it's a MS disc thing!
You need a good file recovery software which recover your all columns like stellar phoenix . Try it might help you..
Cheers..
Remove that post it is against forum rules to talk about password removal.
If you are on a company network, and are saving to that network, often they can recover a file that was saved the day before
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks