How to get Excel to work faster

S

Siva

I have a file, that is +- 200MB in size, and has +- 150 worksheets with 700
lines of formulaes in each worksheet.

Problem is that when I update the one sheet 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?
 
S

Scoops

Hi Siva

You could turn auto calculation off and then specify which cells to
calculate via vba

Regards

Steve
 
C

Carim

With Tools Options Calculation Manual, you will decide with F9 to
calculate only when it is really needed ...

HTH
Cheers
Carim
 
D

Don Guillett

Since it's friday, in addition to the other answers, you could try a whip.
 
Top