VLOOKUP takes forever

T

tyates

I have a Macbook Pro 2.16GHz Core Duo with 2GB of RAM. I an using VLOOKUP to pull in data to a single column from a list 20,000 rows of data. Should it take more than 5 minutes for excel to calculate this? The fan is spinning like crazy on my Macbook Pro well.
 
N

Niek Otten

It shouldn't.
But if your table is imported and calculation is automatic, the VLOOKUPs will be recalculated for each line that is entered
(because the table changes).
That might take very long.

If this is the case, set Calculation to Manual during the import process.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a Macbook Pro 2.16GHz Core Duo with 2GB of RAM. I an using VLOOKUP to pull in data to a single column from a list 20,000
rows of data. Should it take more than 5 minutes for excel to calculate this? The fan is spinning like crazy on my Macbook Pro
well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel too slow ... and common crashes 0
Excel 2008 is painfully, nearly unusably slow w/charts 8
Excel very slow to save and work with pivots 8
Excel 2008 Keeps Crashing - Is there a fix? 7
Multiple rebuilds 3
Excel 2008 version 12.1.5 is still slow forlarge files with charts 5
Objects Redraw Slowy on MacBook Pro 7
slow sorting, data entry, excessive memoryuse, increasing file size 0

Top