View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Siva[_2_] Siva[_2_] is offline
external usenet poster
 
Posts: 1
Default Make Excel 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?