Well, this problem occurs when excel file gets corrupted or damage. In such case, When you try to open the .xls or .xlsx file, your whole document will not open properly and only characters displayed on the screen. For this, you should take the help of professional excel recovery tool. The tool is capable to repair corrupt excel file and recover the file in their original format. Excel Restore Toolbox can help you.
http://www.excel.restoretools.com/