Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which sheet gets calculated first for iterations?
I have a workbook that has 5 sheets, each of which have cells that
refer to one another. It is important that one sheet be fully calculated, then the next, and so on. Does excel calculate sheets in order (i.e. 1 to 5) or does it do something else? I am running it with a manual calculations and iterations allowed. I am using Excel 2002. Thanks, Abe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which sheet gets calculated first for iterations?
Excel calculates sheets in alphabetical order. See
http://www.decisionmodels.com . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Abe" wrote in message ups.com... I have a workbook that has 5 sheets, each of which have cells that refer to one another. It is important that one sheet be fully calculated, then the next, and so on. Does excel calculate sheets in order (i.e. 1 to 5) or does it do something else? I am running it with a manual calculations and iterations allowed. I am using Excel 2002. Thanks, Abe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which sheet gets calculated first for iterations?
It has to do with dependancies. If the Value of Cell A1 depends on B1 and B1
depends on C1 then C1 is calc'd first, followed by B1 and then A1... -- HTH... Jim Thomlinson "Abe" wrote: I have a workbook that has 5 sheets, each of which have cells that refer to one another. It is important that one sheet be fully calculated, then the next, and so on. Does excel calculate sheets in order (i.e. 1 to 5) or does it do something else? I am running it with a manual calculations and iterations allowed. I am using Excel 2002. Thanks, Abe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Field Row - (For Balance Sheet) | Excel Discussion (Misc queries) | |||
# of iterations | Excel Worksheet Functions | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Forcing VBA to wait until sheet completely calculated | Excel Programming |