I have a weird one with a user this morning. A large Excel file (xls format) that opens succesfully on other PC's including my own has issues on one PC. The user gets an error dialog box that says "Unable to Read File". When OK is clicked the file does open, but the results in some columns that contain formulas are not correct. There are many formulas, vlookups, etc., but no macros in the file.
The same file, it's save on a network, can be opened successfully on other PC's including my own. I'm at a loss as to what to do. Wouldn't the file be unreadable on all PC's if corrupt? Also, wouldn't the user see the same results in other spreadsheets if Excel were corrupt or damaged on his PC? He can open all other Excel files without issue.
How do I troubleshoot this one? Thanks.