Does anyone knoe how to get excell to calculate by rows instead of columns. we are having some software written and the programmer wrote code based on rows being calc. before column.thanks.

I'm not sure I understand what you mean. What is it trying to calculate by columns? Are we talking VBA code? You may be able to use something with the transpose function - if you give some more details I'll see what I can do.

There's a thread somewhere round here where I explain some of the horror that is the order in which Excel recalculates...As gjlipman says, you may be able to solve it by transposition, though presumably this is after you've strangled the programmer.You've seen the scene from Carrie, where the bloody hand reaches out from the grave, and grabs you ?That's the design philosophy at work here. I fear this problem won't stay dead.I take it that we're dealing here with VBA user defined functions ?If so, then the exact way you write the formula can alter the order in which supporting cells are evaluated, and in some casesalter the number of times that the VBA function is called.