No idea, based on your description... your one guess, based on limited information provided to date...

File/Options/Formulas/Enable iterative calculations.

But, it is a blind guess!