Forum

Yes, I didn't press Start Upload. I had to reduce the number of rows from 2,000 to 160 to shrink the file size. And now it calculates much faster. Tha...

Hi Catalin, I did run a profiler program before. It took 3-1/2 days. What it showed was that 3/4 of the total calculation time is taken up by formul...

By the way, a friend ran this file on his machine. It's about the same as my computer, except that it has 16GB RAM whereas mine has 8. We both have ab...

Hi Mynda, Let me try avoiding those array formulas first. I'm almost always using them with SUMPRODUCT formulas. Aside from trial and error, what a...

Thanks, Christopher, It is saved in Excel 2016 in xlsb format. Saving it in xlsm format has no effect on the calculation time.