When I open an excel file, I get Err502 in most fields. How do I get around this?

When I try and open an excel file from a trusted party, most / all fields have Err502 in them. When opened in Excel or OpenOffice - no probs.