HAVING A FORMULA GLICHE???
 

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!!!

HAVING A FORMULA GLICHE???
 

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.


--
Kevin Backmann


"TRESSA WYKOFF" wrote:

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!!!

HAVING A FORMULA GLICHE???
 

"TRESSA WYKOFF" <TRESSA wrote in message
...
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!!!

Please turn off your caps lock key.

HAVING A FORMULA GLICHE???
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"TRESSA WYKOFF" <TRESSA wrote in message
...
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!!!

HAVING A FORMULA GLICHE???
 

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

"Kevin B" wrote:

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.


--
Kevin Backmann


"TRESSA WYKOFF" wrote:

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!!!