| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
order of calculations in Excel
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Need to automatically number order forms in excel upon opening? | Excel Discussion (Misc queries) | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| data entry in excel by linking to other word doc. or excel sheets | Excel Worksheet Functions | |||
| Can Excel list order according to Total scores? | Excel Worksheet Functions | |||
Threaded Mode
