Fixing Formulas

[hami812]

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!

[NBVC]

Unhide the Calculations tab, and copy down all formulas E11 to Z11 so that you re-align the references.

[hami812]

Thank you soo much! That worked in seconds. I appreciate it!!