Thank you so much... I've been stumped by this for some time.

Can you please tell me how you managed to locate these circular references? My circular reference button was always grayed out in the error checking function, and the status bar was pointing me to all sorts of cells as a circular reference, some of which only tied back to a simple constant cell or a date. How were you able to locate the actual cause of the error?