Which sheet gets calculated first for iterations?

  • Thread starter Thread starter Abe
  • Start date Start date
A

Abe

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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iteration Calculations between sheets 1
WorkBook_Open Event Order 3
Iteration funtion 2
Is there anyway to find out which cell is being calculated? 2
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Iterating through a ComboBox's values 6
Controlling execution of a Sub Procedure 1
selecting multiple cells from multiple worksheets for printing 0

Back
Top