View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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