Microsoft Visual Basic "File not found": Excel appears to have autosaved data from one file over another that now has problems opening and appears to have had all its sheets replaced by those of the other file.

Question

Hi, I've searched around to see if anyone has a solution to this issue and thus far have come up empty handed so I am hoping someone here can help. Last night I had several files open at one time. I saved them on closing. This morning when I have tried to re-open one of those files Excel comes up with a "Microsoft Visual Basic - File not found" message box.

When I click "OK" a new message box says "Excel found unreadable content in 'Daily Summary.xls'. do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

When I click "Yes", it opens up a file it calls "Daily Summary.xls [Repaired]" but the file has none of the data from the sheet as it was last saved and instead replicates all the sheets from another file, which was opened yesterday. There was a hyperlink to this other file in the original "Daily Summary.xls" but I fail to see how this could have happened.

I really do not want to have to waste time rebuilding a worksheet that took months of incremental work to create in the first place so I hope someone out there knows how to resurrect the original file?

Thanks in advance. 

---

Answer 1

If you are using Vista or Seven you may be able to recover "Previous Versions"