how to restore an excel file to an earlier point?

Question

i just realised that last week end i saved a file with some incorrect data and i want to go back to the same file before i made the changes

Answer 1

What version of windows or microsoft office are you using?

Sometimes as you are working on an excel (or word) document, the program automatically saves a temporary version of the file. Sometimes they are hidden so you may have to go into folder options and click on show hidden files. I am not sure when these temporary files are removed to your recycle bin but it may be a good idea to change the folder options and do a search.


File with no filename Extension and displays with a file type of “File” instead of “Microsoft Excel Workbook” and have funny looking names like 7655D900 or 2CB4D900 which are hexadecimal digits were created when Excel was working on a file. Be sure to look at the datetime stamps in the directory. If you find something interesting right-click on it and open in Excel, then do a file, Save As giving it a distinctive name including the date such as Junk_7655D900_20040629.xls and you can compare it with the other file.

How to show hidden files:
---------------- -----------------------
Click to open “My Computer” and then select “View”, “Folder Options”. Select the “View” tab and then scroll down to the entry that says “Hide file extensions for known file types” and make certain it’s not checked.

Answer 2

If you kept saving the same work book, it overwrites your previous data so you cannot restore those written over data.

There had been many times when we do these mistakes and we have to start from scratch, all over again.

Excel keeps backup files so search your directory. (faint Do you have a portable memory card? Save it there or on a different hard drive partition next time.

I think most of us just start all over again.

Answer 3

equipment restoration regrettably would not delete something. even nonetheless some viruses could be undone. FOR equipment restoration: click initiate, factor to All classes, factor to upload-ons, factor to equipment approaches, and then click equipment restoration. equipment restoration starts off. on the Welcome to equipment restoration web site, click restoration my pc to an previously time (whether that is no longer already chosen), and then click next. on the opt for a restoration factor web site, click the main present equipment restoration factor interior the in this checklist, click a restoration factor checklist, and then click next. be conscious A equipment restoration message might seem that lists configuration differences that equipment restoration will make. click ok. on the be certain restoration factor decision web site, click next. equipment restoration restores the previous residing house windows XP configuration, and then restarts the pc. go on line to the pc as Administrator. The equipment restoration restore finished web site is displayed. click ok.

Answer 4

Sorry bud but you will have to remember the changes.