why does excel 2000 take a long time to calculate formula?

J

Jose

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
 
N

Niek Otten

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
 
J

Jose

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top