Calculation Log

[aki]

Hi,

I have programmed a valuation model in an Excel Worksheet with VBA. A
full calculation round takes about six minutes.

I am quite sure it can be cut down by 4 minutes at least by more
efficient programming, but I wonder whether it is possible to get a
dump of the caluclations that Excel does (And the time taken)? In that
case I could easily identify the unnecessary calculations.

Hope to hear from you...

aki

 

[Niek Otten]

A tool to analyze your workbook can be downloaded here:


www.decisionmodels.com

Lots of tips about calculation speed too.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I have programmed a valuation model in an Excel Worksheet with VBA. A
| full calculation round takes about six minutes.
|
| I am quite sure it can be cut down by 4 minutes at least by more
| efficient programming, but I wonder whether it is possible to get a
| dump of the caluclations that Excel does (And the time taken)? In that
| case I could easily identify the unnecessary calculations.
|
| Hope to hear from you...
|
| aki
|

 

[aki]

I read that Excel recalculates named ranges everytime a referring
formula is recalculated. That may be an important reason. I have
lavishly used named ranges to make the model more understandable.

Is there any solution for this other than removing the names? And is
this really useful?

Also, the interesting fastexcel is a paid tool. Any other (Free )
tips are welcome!

aki