Excel performance analysis - Software

dispelthemyth

Well-known Member
Joined
Mar 16, 2006
Messages
638
Do you know of any software that analyses an Excel workbooks performance (i.e. calculation speed) and determines the bottlenecks, i.e. DataTables, slow formulas etc?

I have a file that takes 0.5s to recalculate but i need to recalculate ~10 times and rerun dozens of times so every milisecond counts and id like to improve the performance as much as possible.

I already try and follow best practice such as not using volatile formulas, i've removed the use of Data tables as that made the calculation speed >1.5s.

I've been using FastExcel v3 but that doesnt seem to give great results
 
Last edited:

jimrward

Well-known Member
Joined
Feb 24, 2003
Messages
1,702
Have you not seen the splash advert for fast excel on this forum at the top of the screen check it out
 

Forum statistics

Threads
1,077,907
Messages
5,337,096
Members
399,125
Latest member
manibiotech

Some videos you may like

This Week's Hot Topics

Top