Excel 2010 shows #Name error while opening a file from previous version (2007). The 2007 excel file has a custom formula which is not in the 2010. I want Excel just to show values and not try to recalculate/refresh the formulas. I have changed the options to "Manual" calculation, but excel is still trying to recalculate formulas when the file, which is created in 2007 version, first opened in Excel 2010.

Is there a way to not to have excel recalculate formulas?