circular reference fix without manual copy / paste

N

nickname

I have a circular reference that I cannot avoid. For no apparent
reason, the circular reference breaks every now and again. I end up
having to manually paste values into one of the circular cells and
then repaste the circular reference. Is there a fix to this?
Shouldn't iterations fix this?

Thanks in advance.
 
Top