close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()