calculate direction

[eggpap]

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

 

[Joel]

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]

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]

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.