| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does excel 2000 take a long time to calculate formula?
I have sheet with many formula. However, it take 10 min to calculate after a
press F9. Can someone tell me what I can do or the reason for this occuring. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does excel 2000 take a long time to calculate formula?
What is your formula? How many do you have? Are there any macros?
In short, without a LOT more information it is unlikely you' ll get any specific help. You may have a look at Charles Willima's site: www.decisionmodels.com which has lots of info about performance of Excel -- Kind regards, Niek Otten "Jose" <Jose @discussions.microsoft.com wrote in message ... I have sheet with many formula. However, it take 10 min to calculate after a press F9. Can someone tell me what I can do or the reason for this occuring. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does excel 2000 take a long time to calculate formula?
Thank Niek for the repsonse. My formula are about 5 vlookup, 3 sumif,
multiplcation. I will check the website. If any more information please let me. Thanks Jose "Niek Otten" wrote: What is your formula? How many do you have? Are there any macros? In short, without a LOT more information it is unlikely you' ll get any specific help. You may have a look at Charles Willima's site: www.decisionmodels.com which has lots of info about performance of Excel -- Kind regards, Niek Otten "Jose" <Jose @discussions.microsoft.com wrote in message ... I have sheet with many formula. However, it take 10 min to calculate after a press F9. Can someone tell me what I can do or the reason for this occuring. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| How do I write an Excel formula to calculate my working time? | Excel Worksheet Functions | |||
| how do i calculate time in & out in excel using a formula | Excel Worksheet Functions | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Hybrid Mode
