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
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
What's your formula?
--
Kind regards,
Niek Otten
"Gazzr" <[email protected]> wrote in
message news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=31075
> View this thread: http://www.excelforum.com/showthread...hreadid=520836
>
Increase the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. ed
Increase the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. ed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks