Most resource-hungry functions?

[Guest]

Does anyone know where I can get a list of excel functions and how much
memory/processor time they use? I'm producing increasingly complex worksheets
& they're starting to bog down. I'm looking for ways to optimise them.

 

[RagDyer]

This might be of interest to you:

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

I costs money though!

 

[Biff]

Also very interesting from Charles Williams:

http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Biff