What version of Excel are you using?. Below is a copy of a another post I replied to concerning this problem with Excel 2007, so perhaps it may help you.
You can have problems trying to open earlier Excel version files in Excel 2007.
These MS websites might help you.