Try there're soft: Active File Recovery, Recover My Files.
http://www.excel.repairtoolbox.com/
Also a demo version of Excel Repair Toolbox to find a lost data from .xls, ..xlsx files. In a cases when the build-in recovery function in Microsoft Excel are not helpful then you can use most effective third-part tool for fixing a bad Excel worksheets: Excel Repair Toolbox.