I want to know the order of calculations, meaning whether cells on sheet 1
are calculated before sheet two, and within sheets whether calculations are
done row by row or column by column. Or is Excel smart enought to work out
all dependencies for the entire workbook and figure out the correct order.
Seems to me you could write a nasty recurring loop. I want to create a
spreadsheet where there are several cumulative calculations based on
calculated values from other sheets, so the order in which Excel calculates
cells values is important. Thanks for any help!