Different Results in each time I click on F9
I have a worksheet with circular reference and I setup the calculation to
manual and with Interation fo 100. The worksheet was working fine, then I add some new lines with the same calculation and for this part of the worksheet each time that I click on F9 I have a different results. At the first time I let the worksheet opened and after some time the value keep the same. Now it is open for a long time but it still changing the value. Any idea what can be happening? Thanks |
Different Results in each time I click on F9
Simone,
That is the problem with circular references - you can get progressive results. For example, if you have cells A1:A9 filled with 1s, and the formula =SUM(A1:A10) in cell A10, the first time it calcs you get 9, then 18, 27, 36....etc.. For better help than that, you will need to post details about your data and formulas. HTH, Bernie MS Excel MVP "Simone" wrote in message ... I have a worksheet with circular reference and I setup the calculation to manual and with Interation fo 100. The worksheet was working fine, then I add some new lines with the same calculation and for this part of the worksheet each time that I click on F9 I have a different results. At the first time I let the worksheet opened and after some time the value keep the same. Now it is open for a long time but it still changing the value. Any idea what can be happening? Thanks |
Different Results in each time I click on F9
Hi Bernie,
I understand your considerantion, but I understood that with iteration Excel will calculate until to get the best result. I have the same formula on other part of the worksheet and it worked well. Even if I change the values when I click F9 it get the wright result. Ah! it is Excel 2003 could be difficult to explain the formula considering that are so many. any other idea? "Bernie Deitrick" wrote: Simone, That is the problem with circular references - you can get progressive results. For example, if you have cells A1:A9 filled with 1s, and the formula =SUM(A1:A10) in cell A10, the first time it calcs you get 9, then 18, 27, 36....etc.. For better help than that, you will need to post details about your data and formulas. HTH, Bernie MS Excel MVP "Simone" wrote in message ... I have a worksheet with circular reference and I setup the calculation to manual and with Interation fo 100. The worksheet was working fine, then I add some new lines with the same calculation and for this part of the worksheet each time that I click on F9 I have a different results. At the first time I let the worksheet opened and after some time the value keep the same. Now it is open for a long time but it still changing the value. Any idea what can be happening? Thanks |
Different Results in each time I click on F9
With iteration Excel recalculates according to what you specify at
Tools/Options/Calculation, Iteration. On Mon, 5 Nov 2007 11:09:01 -0800, Simone wrote: Hi Bernie, I understand your considerantion, but I understood that with iteration Excel will calculate until to get the best result. I have the same formula on other part of the worksheet and it worked well. Even if I change the values when I click F9 it get the wright result. Ah! it is Excel 2003 could be difficult to explain the formula considering that are so many. any other idea? "Bernie Deitrick" wrote: Simone, That is the problem with circular references - you can get progressive results. For example, if you have cells A1:A9 filled with 1s, and the formula =SUM(A1:A10) in cell A10, the first time it calcs you get 9, then 18, 27, 36....etc.. For better help than that, you will need to post details about your data and formulas. HTH, Bernie MS Excel MVP "Simone" wrote in message ... I have a worksheet with circular reference and I setup the calculation to manual and with Interation fo 100. The worksheet was working fine, then I add some new lines with the same calculation and for this part of the worksheet each time that I click on F9 I have a different results. At the first time I let the worksheet opened and after some time the value keep the same. Now it is open for a long time but it still changing the value. Any idea what can be happening? Thanks |
All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com