formulas are not repeating across the board.
 

The formulas that I have put into the program, Example: =sum(b2+c2+d2) is not
adding my numbers up in the designated cells. It is like the program has been
contaminated or locked up some how. All my files that I use excel with are
not responding.

formulas are not repeating across the board.
 

First of all, replace the formula with

=SUM(B2:D2)

however that won't affect your problem but you should not use SUM in the way
you used it so either B2+C2+D2 or the simpler SUM(B2:D2). What happens if
you press F9?


--
Regards,

Peo Sjoblom




"Sharna" wrote in message
...
The formulas that I have put into the program, Example: =sum(b2+c2+d2) is
not
adding my numbers up in the designated cells. It is like the program has
been
contaminated or locked up some how. All my files that I use excel with are
not responding.

formulas are not repeating across the board.
 

Has the calculation mode been changed to manual, such as opening up a
workbook that had it's calculation mode set to manual with no other
workbooks open?

To check this possibility out, goto Tools, Options, Calculations, and look
near the top of the dialog box.

Ronald R. Dodge, Jr.
Master MOUS 2000

"Sharna" wrote in message
...
The formulas that I have put into the program, Example: =sum(b2+c2+d2) is
not
adding my numbers up in the designated cells. It is like the program has
been
contaminated or locked up some how. All my files that I use excel with are
not responding.

formulas are not repeating across the board.
 

F9 may or may not work. I have had too many issues of F9 not working
properly as it was intended to work. Shift-F9 (Sheet level) or Alt-Ctrl-F9
(Forced full calculation) does work. This last one has more or less
replaced the F9 key as it makes sure everything gets calculated.

Ronald R. Dodge, Jr.
Master MOUS 2000

"Peo Sjoblom" wrote in message
...
First of all, replace the formula with

=SUM(B2:D2)

however that won't affect your problem but you should not use SUM in the
way you used it so either B2+C2+D2 or the simpler SUM(B2:D2). What happens
if you press F9?


--
Regards,

Peo Sjoblom




"Sharna" wrote in message
...
The formulas that I have put into the program, Example: =sum(b2+c2+d2) is
not
adding my numbers up in the designated cells. It is like the program has
been
contaminated or locked up some how. All my files that I use excel with
are
not responding.

formulas are not repeating across the board.
 

I never had any problems


--
Regards,

Peo Sjoblom



"Ronald Dodge" wrote in message
...
F9 may or may not work. I have had too many issues of F9 not working
properly as it was intended to work. Shift-F9 (Sheet level) or
Alt-Ctrl-F9 (Forced full calculation) does work. This last one has more
or less replaced the F9 key as it makes sure everything gets calculated.

Ronald R. Dodge, Jr.
Master MOUS 2000

"Peo Sjoblom" wrote in message
...
First of all, replace the formula with

=SUM(B2:D2)

however that won't affect your problem but you should not use SUM in the
way you used it so either B2+C2+D2 or the simpler SUM(B2:D2). What
happens if you press F9?


--
Regards,

Peo Sjoblom




"Sharna" wrote in message
...
The formulas that I have put into the program, Example: =sum(b2+c2+d2)
is not
adding my numbers up in the designated cells. It is like the program has
been
contaminated or locked up some how. All my files that I use excel with
are
not responding.

formulas are not repeating across the board.
 

Well it seems to depend. With smaller less complex formulas/workbooks, it
seems to work okay, but as the complexity increases, the odds of the F9 key
working properly decreases. There has been numerous times in the past when
I have attempted to use the F9 key to calculate only to find that it didn't
calculate all the way through, so when MS came out with the Alt-Ctrl-F9 to
address this issue in Excel 2000, this made my life so much easier to work
with. I even tested the F9 in XL2000, and it still didn't work properly for
me, but then I have more complex worksheets and workbooks too.

For the set of workbooks that I have a huge number of calculations, they are
in an instance of Excel to themselves with the calculation mode set to
Manual, while other workbooks with limited number of calculations are in a
separate instance of Excel with the calculation mode set to Automatic. I
typically have 2 or 3 difference instances of Excel up on the computer at
one time unless I am testing things out that may need to be proven it's not
just a system resource issue.

Ronald R. Dodge, Jr.
Master MOUS 2000

"Peo Sjoblom" wrote in message
...
I never had any problems


--
Regards,

Peo Sjoblom



"Ronald Dodge" wrote in message
...
F9 may or may not work. I have had too many issues of F9 not working
properly as it was intended to work. Shift-F9 (Sheet level) or
Alt-Ctrl-F9 (Forced full calculation) does work. This last one has more
or less replaced the F9 key as it makes sure everything gets calculated.

Ronald R. Dodge, Jr.
Master MOUS 2000

"Peo Sjoblom" wrote in message
...
First of all, replace the formula with

=SUM(B2:D2)

however that won't affect your problem but you should not use SUM in the
way you used it so either B2+C2+D2 or the simpler SUM(B2:D2). What
happens if you press F9?


--
Regards,

Peo Sjoblom




"Sharna" wrote in message
...
The formulas that I have put into the program, Example: =sum(b2+c2+d2)
is not
adding my numbers up in the designated cells. It is like the program
has been
contaminated or locked up some how. All my files that I use excel with
are
not responding.