Formulas Not Working

N

New2Macros

Would anyone know why at times no formulas update until I save the
spreadsheet? I can put in the easiest formula, and it does not respond until
I hit "save."
 
B

Bob Phillips

IS your calculation mode set to manual, Tools>Options>Calculation?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
N

New2Macros

That seems to be it. It is odd, because sometimes it will work for a while
and then suddenly quit.
 
B

Bob Phillips

I had forgotten about that one, will use it more often now my memory has
been jolted <g>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top