calculation order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Row x row, or col x col? Are all iterations performed on a cell before going
to the next one? Excel 2003
 
Neither, Excel looks at the interrealtionship between cells i.e what is
dependant upon what, looks at what has changed since the last calculation and
then work out a calculation sequence. It then calculates and stores that
information ready for the next calculation. Not sure if this has changed for
2007 but it would seem unlikely to have.

Mike
 

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

Back
Top