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...
I would recommend switching from a Vlookup to an Index/Match formula. I have done this with a similar file with a ton of formulas and was able to greatly reduce the lag time.