Formulas Not Working

[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."

 

[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)

 

[Niek Otten]

Check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[New2Macros]

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

 

[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)