Problem: Some of the Excel spreadsheets created in Excel 2003 are not calculating when opened in Excel 2010.
The root cause is that the spread sheet is set to manually calculate formulas. You need to set the spreadsheet up to calculate automatically. To solve this,
- click on the Formula Ribbon
- select Calculate Option
- click on Automatic