How to handle "Object reference not set to an instance of an object" error?

I just tried to open an Excel translation project I've been working on for several days and I get the error "Object reference not set to an instance of an object," and the project won't open. Why does this happen and how can I solve the problem?