Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Ways to undelete / retrieve / unsave Excel Files ? ? ?


  • This topic is locked This topic is locked

#1
TheWern

TheWern

    Member

  • Member
  • PipPip
  • 81 posts
Hi,

Whilst I was working on one spreadsheet, I wanted to open another existing file. But, instead of going 'File' and 'Open', I clicked on 'File' then 'save as'. I then selected the file I wanted to open and clicked yes to the pop-up question before realizing that I had just 'saved as' not 'opened'.

Now ABC.xls is duplicated in DEF.xls.

Is there a way to restore DEF.xls to how it was originally ? ? :) :) :)

A net search came up with a MS answer which sounded like what I want but there are no instructions on how to implement:-
http://support.microsoft.com/kb/150368


I hereby promise not to muck about with important files whilst talking on the cell phone ever again ! ! ! ! ! ! :)

Thanks again,
  • 0

Advertisements


#2
Mike

Mike

    Malware Monger

  • Retired Staff
  • 2,745 posts
Hi there,

The problem is that you didn't delete the file, if this were the case there would be a chance to retrieve it as there are programs available to recover files in your case, if I understand right, is that you over-wrote an exsisting file.. so DEF.xls is now ABC.xls, if thats the case then getting DEF.xls back is not do-able as far as I know.

I'm sorry! I tried to replicate it myself hoping I could find a way!

Maybe someone else will come along with better news. And a side note: With very important documents set it to "Read only" by right clicking on the file > clicking on "properties" and checking "Read-only" this will prevent this accident from repeating itself! Also make backups by copying the file to a different location.

Good luck,

Mike
  • 0

#3
TheWern

TheWern

    Member

  • Topic Starter
  • Member
  • PipPip
  • 81 posts
Hi Suerte,
Did you look at the Microsoft Help page? I have copie a part below... in Red that suggests that the Excel program 'deletes' the file and that it can possibly be resurected. But unfortunately, the rest of that article is above my head.

SUMMARY
In Microsoft Excel, if you save unwanted changes to a file, you may be able to recover the original file.
MORE INFORMATION
When you save changes a Microsoft Excel file, the following occurs:

• The changed file is saved to a temporary file.
• The original file is deleted.
• The temporary file is renamed to the original file name.
For additional information, please see the following article in the Microsoft Knowledge Base:
103329 (http://support.micro...b/103329/EN-US/) XL: Error Message When You Try to Save a File
The deleted original file is located in the same directory or folder as the newly modified file in Windows. On the Macintosh, temporary files are placed in an invisible folder called Temporary Items in the root level of the hard disk.

  • 0

#4
Mike

Mike

    Malware Monger

  • Retired Staff
  • 2,745 posts
Hi there, from here on I would probably be pointing you in the wrong direction, from what I know and have experienced is that when I save file A as file B, the contents of File B is overwritten and as a result you get the contents of File A with the name of File B (confusing enough :)) and I do not know a way. After looking over the article it seems you can use a recovery program and "undelete" the file, how and with what is beyond me. There are many techs here much more able to help you and they will come around in due time.

Sorry!

Mike
  • 0

#5
TheWern

TheWern

    Member

  • Topic Starter
  • Member
  • PipPip
  • 81 posts
Thanks for trying Mike.

I tried using ParetoLogic but could not find the file amongst the list.
The article seems to suggest the use of a DOS command

Anyone? ? ? ?

Thanks
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP