Re: Make Excel work faster

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Other than re-designing the whole project (use a database?) you could try
not to work with lookup work*** functions, but get the *** ranges in
arrays and do the lookups by looping through these arrays in VBA.
I find that this is often much faster.
If those ranges can be sorted you could even make it faster by using
binary search algorithm's on the arrays, rather than simply looping from
lbound to ubound.

RBS

"Siva" <Siva Govender@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3306E169-01A5-4269-9165-3292C2AA9149@xxxxxxxxxxxxxxxx
I have a file, that is +- 200MB in size, and has +- 150 worksheets with 700
lines of formulaes in each work***.

Problem is that when I update the one *** where the lookup is, it takes
about 10min to do the calculation.

I am also running a PIV 3Ghz HT with 1gig RAM.

How can I get Excel to perform faster?

.

Quantcast