# Excel Calculation Direction Question

1. ## Excel Calculation Direction Question

My understanding of Excel is that the calculations are performed in Column A first and then down through the rows in Column A. After all the calculations are finished in A, the calculation moves over to Column B and down the rows in B. Is this true?

I know that Excel is a little more complicated than that especially when it creates a queue for calculations, etc. However, assuming there's no calculation list/queue, would the above be correct?

Thanks,

Paula

2. ## Re: Excel Calculation Direction Question

http://www.decisionmodels.com/calcsecretsc.htm

3. ## Re: Excel Calculation Direction Question

See this page for just about everything to do with the calcualtion process.
I'm intrigued as to why you need to know though?

4. ## Re: Excel Calculation Direction Question

Originally Posted by Special-K
Thanks!

P

5. ## Re: Excel Calculation Direction Question

Originally Posted by romperstomper
See this page for just about everything to do with the calcualtion process.
I'm intrigued as to why you need to know though?
I build economic models in excel for a living. Part of that job is to teach others to build efficient spreadsheets. I'm trying to show people how excel actually performs its calculations, such that people can set up their spreadsheets in such a way that minimizes the file size, performs calculations efficently, reduces links, etc.

All that being said, I wasn't exactly sure how to explain how excel performs its calculations. The top down methodology that I described in my original post was more aimed at the "dependancies" that you replied with.

Thanks for that.

Paula

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1