Calculating columns first in Excel

[ScorchedLemonade]

Hi,

I have a sheet in Excel in which some of the cells in row 1 depend upon values from earlier columns but Excel always seems to calculate rows first so that it reports errors in these cells which leads to problems in other places.

Is it possible to force columns first (the columns are long enough that I can't transpose) or if I put the columns in different sheets would that help?

A related problem on the same sheet is that it would be better for automation purposes to have an array output for some cells but whose height depends on the value of some other cell (so that I would have an array of formulae in cells F3:H? where ? is the value of cell F1, which would be calculated from the last entry in column 1 (hence a need for columns first) for instance).

I tried writing it in VB (which was possible) but it was interminably slow.

Thanks if you got this far,

Richard Carr.

 

[onedtent]

Excel doesn't really have any particualr order in which it calculates things. if it's a simple sheet, most probably it will go down and over. u can find more about calc order at

http://www.decisionmodels.com/calcsecretsc.htm

if u r having problems, chances r u have circular reference.