A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Perhaps your Excel 2007 version files are not opened in Excel 2010 properly - perhaps Excel 2010 needs some setting / re-setting.
Try to see if the following helps:
Hope this is Helpful.