Problem w/ Formulas Updating

[bascher]

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!

 

[nbrcrunch]

Could be a rounded value in sheet1 that is not being rounded on sheet2. Try preceding your formula on sheet1 with INT()

 

[bascher]

Nope. Neither calculation has a round function before it.

 

[nbrcrunch]

yeah, its hard troubleshooting when you can't see it "live." Next is to check the formatting of the cell. I a test with the value 500.89 in one cell. Then in another i referenced that cell. Then in the 2nd, I formatted it as no decimals. It returned 501. I would venture you know all this, but I'm trying to throw out one thing at time here. (And at this point I can't readily think of what else it could be.)