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
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
quot;Josequot; lt;Jose @discussions.microsoft.comgt; wrote in message ...
gt;I have sheet with many formula. However, it take 10 min to calculate after a
gt; press F9. Can someone tell me what I can do or the reason for this occuring.
gt; Thank you
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
Josequot;Niek Ottenquot; wrote:
gt; What is your formula? How many do you have? Are there any macros?
gt;
gt; In short, without a LOT more information it is unlikely you' ll get any specific help.
gt; You may have a look at Charles Willima's site:
gt; www.decisionmodels.com
gt; which has lots of info about performance of Excel
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Josequot; lt;Jose @discussions.microsoft.comgt; wrote in message ...
gt; gt;I have sheet with many formula. However, it take 10 min to calculate after a
gt; gt; press F9. Can someone tell me what I can do or the reason for this occuring.
gt; gt; Thank you
gt;
gt;
gt;
- Oct 22 Sun 2006 20:09
why does excel 2000 take a long time to calculate formula?
close
全站熱搜
留言列表
發表留言