xlsm file created in office 2007 wont open correctly in office 2010

[Millsy79]

Hi

A pupil has done a very complex excel spreadsheet with macros involved and it works fine when using office 2007, which she has at home. however here in the school the classroom PC's are running Office 2010 and when she tries to run open the spreadsheat the following error occurs

 

'Excel found unreadable contenet in (spreadsheet Name.xlsm) Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes.'

 

when you click yes it attempts to repair the file and displays the following.

 

'removed part:/xl/calcChain.xml part (caulaton properties)'.

 

The spreadsheet will then open but with all the macros, drop down boxs etc removed. If you try to open the file with office 2007 again after doing this it still works fine.

Is their any way of getting this file to open correctly in office 2010?