Forum Discussion
Excel files are very slow
Some Excel files are very slow. I tried the solutions in all the articles on the internet but no result. Can you help me ?
Download my RefTreeanalyser from https://jkp-ads.com/reftreeanalyser.asp
After installing, click the "All sheet statistics" button, it will time the calculations for each worksheet. That should narrow it down to the slowest sheet(s).
If you purchase a license you can narrow it down even further by clicking "Report formulas", that will list all unique formulas and their calculation time. You can sort the resulting table on the calc time to get the most "expensive" ones.
After installing, click the "All sheet statistics" button, it will time the calculations for each worksheet. That should narrow it down to the slowest sheet(s).
If you purchase a license you can narrow it down even further by clicking "Report formulas", that will list all unique formulas and their calculation time. You can sort the resulting table on the calc time to get the most "expensive" ones.