View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abe[_4_] Abe[_4_] is offline
external usenet poster
 
Posts: 24
Default 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