Re: Formulas will not update!
- From: <Andy>
- Date: Wed, 14 Jun 2006 12:06:38 +0100
Hi
Make sure that your calculation is set to Automatic. It's in
Tools/Optopns/Calculation
Hope this helps.
Andy.
"cerpintax" <cerpintax.29e29z_1150282802.5786@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:cerpintax.29e29z_1150282802.5786@xxxxxxxxxxxxxxxxxxxxxxxx
I don?t know if anyone can help me but this problem is frustrating me.
I will try to explain as best I can. When I have a column of data, say
reference
A1 to A9 with a formula beneath it in A10 being that the formula is
=SUM(A1:A9) when I update any of the data in A1 to A9 the figure in A10
does not update. The only way to get it to update is to click in A10
where the formula is and then click in the formula bar and press enter;
the formula seems to recalculate after this and it works or you need to
save it and it works. It should work right after any change in the
data being added, I don't know what is happening or has happened but
any solution to this problem would be much appreciated.
Thanks:
:)
--
cerpintax
------------------------------------------------------------------------
cerpintax's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=35411
View this thread: http://www.excelforum.com/showthread.php?threadid=551805
.
- Follow-Ups:
- Re: Formulas will not update!
- From: cerpintax
- Re: Formulas will not update!
- References:
- Formulas will not update!
- From: cerpintax
- Formulas will not update!
- Prev by Date: Re: Measure between date time A to date time B
- Next by Date: Re: Measure between date time A to date time B
- Previous by thread: Formulas will not update!
- Next by thread: Re: Formulas will not update!
- Index(es):
Relevant Pages
|
