Hello,
I am building a large excel model for work with around 50 sheets that has gotten quite large (20+MB). Today, I ran across a strange problem in my worksheet.
I have a formula on a sheet (Lets say sheet2) that is linked to another cell on a different sheet (sheet1). Basically the formula in the cell is something like this: =Sheet1!D5
Sheet1!D5 is equal to 500 (this is not an inputed value, but a calculation), but the link on sheet2 shows a different number, 501.
I have my calculations on automatic and iterations on (100 w/ maximum change 0.001). I think the problem is that my model is very circular. Any suggestions on fixes for this problem.
Thanks!
I am building a large excel model for work with around 50 sheets that has gotten quite large (20+MB). Today, I ran across a strange problem in my worksheet.
I have a formula on a sheet (Lets say sheet2) that is linked to another cell on a different sheet (sheet1). Basically the formula in the cell is something like this: =Sheet1!D5
Sheet1!D5 is equal to 500 (this is not an inputed value, but a calculation), but the link on sheet2 shows a different number, 501.
I have my calculations on automatic and iterations on (100 w/ maximum change 0.001). I think the problem is that my model is very circular. Any suggestions on fixes for this problem.
Thanks!