Quote Originally Posted by teylyn View Post
I think the file is corrupt. None of the usual methods work for me.

There is a custom view in the file, but deleting it won't change anything. When I open the file as you sent it, I get a message "Data may have been lost", which for me indicates that Excel can't read everything OK.

Saving as html and then back to xls also does not reduce file size significantly.

So, I don't know what's caused it and I don't know how to repair it.

Sorry.
No apology required! I appreciate your efforts!

The key thing is that you have told me that I am not simply an idiot and unable to follow instructions! I recall the formation of that custom view though it was a failure and I didn't even know it was still there. I don't get that message about "data may have been lost" so perhaps my version of excel is not working correctly. I will do an update and try to rule that out. However, I must assume that there is a bit of a bug in excel that allows this to happen. I do have a tendency to use 'ctrl-A' to copy and paste, I select whole columns instead of definite ranges and (at least in that document) I had specifically moved to the end of the sheet range and hidden all those extra cells.

A bit more care and I can stop it reoccurring. Overall, another little MS annoyance!