| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Make Excel Work faster
You could set calculation to Manual while entering the data and recalculate with F9.
10 minutes seems a bit long, but we don't know your formulas. Especially VLOOKUP and HLOOKUP are very sensitive for the 4th argument. For many tips about performance, especially lookups, check he www.decisionmodels.com And/or post your formulas (in this thread) -- Kind regards, Niek Otten "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 | |||
| Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
| How to make Excel 2003, not IE 6, open Excel files from a web? | Excel Discussion (Misc queries) | |||
| How do I make at boxplot in Excel? | Excel Discussion (Misc queries) | |||
| POI doesn't work with Excel 97 | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Hybrid Mode
