Hi,
I have built a very complicated financial spreadsheet at work that requires MANY circular references. I recently needed to change something and add another circular reference, and now that section of the file is not calculating correctly. When I go to into the "Evaluate Formula" it calculates it correctly, shows +1000 let's say, and then if you hit it one more time it says =0. Is it possible to reach a maximum number of circular references that the file can handle? I have tried running 100, 150, 200, and 1 iterations. Is there any way to fix this? Thanks in advance for any help! I have been toiling over this thing for too long!
I have built a very complicated financial spreadsheet at work that requires MANY circular references. I recently needed to change something and add another circular reference, and now that section of the file is not calculating correctly. When I go to into the "Evaluate Formula" it calculates it correctly, shows +1000 let's say, and then if you hit it one more time it says =0. Is it possible to reach a maximum number of circular references that the file can handle? I have tried running 100, 150, 200, and 1 iterations. Is there any way to fix this? Thanks in advance for any help! I have been toiling over this thing for too long!
