Making faster workbooks

[Oaktree]

I'm not sure if this is already referenced somewhere on the board, but there is a really good writeup about improving workbooks' performance here:

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

The title says it's for 2007, but the majority of its content applies to all versions of Excel.

 

[erik.van.geit]

Thanks you, Oaktree!
I've spent quite some time to check out that interesting page


for me "IFERROR" is the revelation of Excel 2007
IFERROR(timexpensive formula, "yourstring")

 

[SydneyGeek]

Cheers for that!

Lots of useful data to look through and assimilate



Denis

 

[Richard Schollar]

Matt

That is good - I just skimmed it and I found the bit on "Period to date sums" absolutely fascinating. Maybe this is obvious to everyone else (?) but to me just having the explanation there in black and white really made me think and consider the problem.

Great article!!!

 

[JazzSP8]

Thanks for the link...

My recent questions on the board have been about it, one way or another at least, and that helped me understand the differences in calculation methods and how its performed.

That said, I am trying not to think about the best option being just to rebuild three of the most "changed over time" workbooks I use daily...