close

Hi,

I am having problems with a spreadsheet where the formulas are not
re-calculating, even though auto calc is on.

If i hit F2 on the formula and then enter it works though.

Any ideas?

Garry--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: www.excelforum.com/member.php...oamp;userid=31075
View this thread: www.excelforum.com/showthread...hreadid=520836What's your formula?

--
Kind regards,

Niek Otten

quot;Gazzrquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I am having problems with a spreadsheet where the formulas are not
gt; re-calculating, even though auto calc is on.
gt;
gt; If i hit F2 on the formula and then enter it works though.
gt;
gt; Any ideas?
gt;
gt; Garry
gt;
gt;
gt; --
gt; Gazzr
gt; ------------------------------------------------------------------------
gt; Gazzr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31075
gt; View this thread: www.excelforum.com/showthread...hreadid=520836
gt;
Increase the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. edIncrease the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. ed

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

    software

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