Make sure your sheet is set to automatic calculation.
<Tools <Options <Calculation tab,
And make sure "Automatic" is checked.
And maybe check out this link to an old thread as to why it might have
changed:
http://tinyurl.com/anahg
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_Carpet" wrote in
message ...
hi i think this is a very basic question but, here goes any way
I have got a basic spreadsheet that i would like to use to do some
accounts it looks like:
Opening
Income
Receipts
TV
Transfer In
Sponsorship
Misc in
Total in
Expenditure
Wages
Maintenance
Transfer Out
Misc_Out
Total out
Closing
Now i'd like to get the closing number so for this on paper i'd just do
opening + Total in - Total out = Closing (total in and total out also
have formulas to get the total. For which i am having the same problem
i am trying to describe) I am sure this is the same for excel but for
some reason it does not automatically update when i change the numbers
in the caculation
so if for example the cal was
11000 + 10000 - 3000 = 18000 but then one of the numbers changed so it
should be
11000 + 9500 - 3000 = 17500 all my numbers on my spreadsheet would
still be showing the first numbers apart from the number i just
manually changed.
How do i get excel to automatically change the numbers as i change the
spreadsheet?
--
B_Carpet
------------------------------------------------------------------------
B_Carpet's Profile:
http://www.excelforum.com/member.php...o&userid=20207
View this thread: http://www.excelforum.com/showthread...hreadid=389695