How to get Excel to work faster
 

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?

How to get Excel to work faster
 

Hi Siva

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

Regards

Steve

How to get Excel to work faster
 

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

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=530833

How to get Excel to work faster
 

look at
http://www.decisionmodels.com/optspeede.htm
http://www.decisionmodels.com/optspeedd.htm

and associated pages.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Siva" wrote in message
...
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?

How to get Excel to work faster
 

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

--
Don Guillett
SalesAid Software

"Siva" wrote in message
...
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?