| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Excel Work faster | New Users to Excel | |||
| Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
| POI doesn't work with Excel 97 | Excel Worksheet Functions | |||
| Windows in TaskBar in Excel doesn't Work the Same as in Word | Excel Discussion (Misc queries) | |||
| Windows in TaskBar in Excel doesn't Work the Same as in Word | Excel Discussion (Misc queries) | |||
Hybrid Mode
