calc order

[Chrissirhc]

Hi,

Whats the best/easiest way to find the calc order of a sheet. I'm using Excel 2002 and want to make sure that the sheets are in the right order...

Thanks,

Chris

 

[SkipVought]

chris,

Please be more careful with your questions.

Please check HELP before posting a question. There is HELP in Excel on Calculation in Workbooks.

Skip,

_[red][/red]

 

[xlbo]

For more info on calculations in excel, have a look here:

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

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Chrissirhc]

Ok - I had checked the msdn site and looked at Geoff's post - Thanks.

I work in an environment where the workbooks have say 30 sheets and there are many UDFs and dlls and addins that they use. It is not easy to manually find out exactly what is being calced before what.

I guess my original post should have read: Is there a way to find out exactly what the calc tree looks like for my sheet perhaps a tool that will build up what sheet is calcing before the other and what cells are getting calced the most... Perhaps I'll be able to spot something as to why the sheet takes 20 minutes to calculate.

Thanks in advance,

Chris

 

[Chrissirhc]

There is actually on that decisionmodels site called fastExcel. Unfortunately I can't get that on my companies PC (various reasons - licensing, beaureaucracy etc...) Any ideas?

 

[xlbo]

As a basic rule, I nbelieve that workbooks calculate from left to right and top to bottom - also from left most sheet to right most sheet so as a starter for 10, any summary sheets should be to the right of data sheets to allow the data sheet to be calced 1st - otherwise, your results sheet will be calced twice

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Chrissirhc]

That is how the sheet has been built... There may be a few overlaps I wanted a quick way to find out...

 

[xlbo]

Not sure there is any way to get the calc tree from excel - the site I posted a link to is pretty much the guru site when it comes to calculation in excel - they have useful tips and tricks there. Other than that, maybe a search of that site will yield something (or a message to the site owners)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question