Forum Discussion
Huge Excel spreadsheet- Slow calculation speed for formulas
I have an excel spreadsheet with about 300,000 records. I am applying a Vlookup formula on the first row and then trying to copy and paste special as formulas to the remaining rows. But, the calculat...
In addition,
In general it's worth to check Excel performance: Tips for optimizing performance obstructions, quite useful tips.
As for the VLOOKUP in it simplest form (no embedded formulas to check criteria, etc.) it takes practically no time to recalculate on 300000 records table. In attached file such simple table is generated, no problems with performance.
Perhaps something else slows recalculation, like array formulas inside.
