Fixing Formulas

I have a problem with a spreadhseet I downloaded from ASQ website used for Quality Control. THe spreadsheet automatically calculates the Gage R&R for a site which I needed to support quickly and had no time to review the accuracy of the formulas. The cells show #ref! in the cell that does not seem to be referenced same data. I do have one that is working correctly, and when I compare the formulas they are identical. I cannot see why its giving me this result. The template is in 2003, but i use 2010

The #ref! formula is =Calculations!$AE$111 The input to this formula comes from a different worksheet called data entry. When I check that worksheet all formating seems OK for exception of one cell M14 which also shows #ref! But the formula was simply dragged from top all the way. One Workbook looks fine and the other seems corrupted. Is this possible. I am not getting it!