The spreadsheet keeps on recalculating all the formulas until it reaches a
constant state, otherwise, it reports a circular reference. It should not
matter what order the sheet is calculated to get to a steady state condition
where all the formulas have been recalculated. Sometimes a formula gets
calculated multiple times if it has two or more inputs.
"eggpap" wrote:
> No, the formulas are not wrong, what is strange is the order in which the
> UDFs are executed. Debugging them I've noted that the addresses of the
> values passed are not in sequence.
>
> Emiliano
> "Joel" <(E-Mail Removed)> ha scritto nel messaggio
> news:214F73EA-7EB2-4B46-9D7E-(E-Mail Removed)...
> > Yuor formulas are wrong. I fyou had a UDF that added 1 to the value
> > passed
> > You woulkd have something like this
> >
> > A B C D
> > E
> > =AddOne(B1) =AddOne(C1) =AddOne(D1) =AddOne(E1) 15
> >
> > The results will have the following
> >
> > 19 18 17 16
> > 15
> >
> >
> > "eggpap" wrote:
> >
> >> Hi,
> >>
> >> i've some udf in a range (suppose A1:Z1) that calculate the values
> >> depending
> >> on the content of another range. When I trig the Full Calculation
> >> (Alt+Ctrl+F9)
> >> Excel starts from the first udf (that is in A1) then from that in Z1,
> >> than
> >> in Y1 etc. and i get
> >> the values increasing from right to left instead from left to right.
> >> Any advice?
> >>
> >> Emiliano
> >>
> >>
> >>
> >
>
>
>
|
Similar Threads
