Obviously some of these suggestions assume that "somehow" you can in fact open the file ... in which case you wouldn't have asked this question would you? It doesn't seem to be a corrupted file, more likely a file too large for Excel (perhaps due to memory constrains - try opening it on a computer with more RAM). Also is your Excel a 32bit where the one which created it is 64bit, the 64bit version can use more RAM, while the 32bit is limited to a maximum of 2GB.

If none of these things work ... then there's a possibility that the XLS/XLSX file has become too large for Excel (Excel has some limits on just how many lines / columns it can handle). Previously I have been able to open such files in LibreOffice Calc (which has much larger limits on this) - in which case I could copy portions of it out to separate files so I don't loose the data.

If even that doesn't work, attempt to link to it through ODBC/ADO drivers (or even importing it directly into a database like Access) - i.e. seeing it as a database source file. Sometimes that can get you into the data inside the file without going through Excel and its limits. Unfortunately it won't help with the formulas inside that file, but at least you should be able to get to the data.

However, if you do find that your spreadsheet is too large for Excel to open, then you should definitely start looking at converting it into a database instead. If not, you'll be running into this sort of issue constantly. I'd say, as soon as you've got more than around 1000 lines in Excel, you should definitely consider moving to something like Access / LibreOffice Base instead - they can very easily handle millions of lines much faster than Excel/Calc can.