HAVING A FORMULA GLICHE???

T

TRESSA WYKOFF

IS ANYONE ELSE HAVING A PROBLEMS WITH FORMULA CALCULATIONS? OUT OF NO WHERE
THIS MORNING, WHEN I COPY A FORMULA TO ANOTHER CELL IT DOES NOT SHOW THE
CORRECT VALUE. ALSO, IF I CHANGE THE VALUE OF A CELL THAT IS INCLUDED IN A
SUM FUNCTION IN ANOTHER CELL, THE VALUE OF THE SUM DOES NOT CHANGE UNTIL I
DOUBLE CLICK THE FORMULA CELL OR TYPE F9. PLEASE TELL ME IF ANYONE ELSE IS
HAVING THIS PROBLEM OR HAS HAD IT IN THE PAST. THANK YOU!!!
 
K

Kevin B

Sounds like you might have calculations set to manual. Click TOOLS, select
OPTIONS and click on the CALCULATION tab. Click the AUTOMATIC to reset the
calculation method.
 
D

Doug Kanter

TRESSA WYKOFF said:
IS ANYONE ELSE HAVING A PROBLEMS WITH FORMULA CALCULATIONS? OUT OF NO
WHERE
THIS MORNING, WHEN I COPY A FORMULA TO ANOTHER CELL IT DOES NOT SHOW THE
CORRECT VALUE. ALSO, IF I CHANGE THE VALUE OF A CELL THAT IS INCLUDED IN
A
SUM FUNCTION IN ANOTHER CELL, THE VALUE OF THE SUM DOES NOT CHANGE UNTIL I
DOUBLE CLICK THE FORMULA CELL OR TYPE F9. PLEASE TELL ME IF ANYONE ELSE
IS
HAVING THIS PROBLEM OR HAS HAD IT IN THE PAST. THANK YOU!!!
Click to expand...

Please turn off your caps lock key.
 
B

Bernard Liengme

Can you find the caps lock key? Using all caps is considered shouting.
Please use you 'inside voice' !!!

Use Tools | Options ; open the Calculation tab; in Calculations area check
the Automatic box

This is not a 'problem' but a feature. With large workbooks it often helps
to enter the data in various cells than do calculations with F9

best wishes
 
T

TRESSA WYKOFF

Thank you sooooo much!!!!!!!!!!!!!!!!!!!!!!!! I've been going crazy with
that!!!!! You definitely did your good deed for the day!!!
 
Top