I have had an excel spreadsheet I worked on now for over 1 and a half. No probs. Last Friday after saving it I went to reopen it and it was corrupted. I went to Microsoft.com and they confirmed the error message was a corruption.
Fortunately with excel it is easy to get DATA out of a corrupt file. So I got the data out. Pasted it into a new spreadsheet and saved it. When I went to open it --> Corruption.
So I uninstalled MS Office. I ran a virus scan (none found) and reinstalled office. I then extraced the data out. Saved it. When I went to reopen it it was fine.
Then thinking as I pasted it it may have been a corrupted formula. So I went back to a blank workbook. I opened the file of data that saved and I pasted it as values only.
It looked Ok. I saved it. Opened it thinking I found my problem. Then I closed it. Tried to reopen it and --> CORRUPTION.
I guess now I will have to piece it together a little at a time to see where the problem is. But just what causes a file to all of a sudden become corrupt?
There are no macros in it. It is has only 3 months of data on it. I used the same file last year for 12 months no problem. That one still opens fine.
There is no memory issue.
Temp files all cleaned out.
The last thing is once I close the corrupt file, if I try to reopen it it says it is still in use. So I have to reboot.
The file is just numbers and the most complicated formula is the sum of a row.