formulas are not repeating across the board.

S

Sharna

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.
 
P

Peo Sjoblom

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?
 
R

Ronald Dodge

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
 
R

Ronald Dodge

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
 
R

Ronald Dodge

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
 
Top