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!

Please note, the question is NOT about order of mathematical operations.

"Kickseek" wrote:

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!

http://support.microsoft.com/default...b;en-us;825012

More info:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kickseek" wrote in message ...
|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!

Fantastic. Thank you, Niek!

"Niek Otten" wrote:

http://support.microsoft.com/default...b;en-us;825012

More info:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kickseek" wrote in message ...
|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!