Any mod/guru up for a challenge (or just want to drive yourself nuts?) OP here has a circ ref in a mess of formulas over 3 sheets...
http://www.excelforum.com/commercial...ml#post3658194
(Good luck, I am often fairly good with circ's, but I will leave this 1 to some1 else)

When you "fix" the formula and copy it down a few rows, there is no CR, but after a few more rows it kickes in