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

IS your calculation mode set to manual, ToolsOptionsCalculation?

--
HTH

Bob

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

"New2Macros" wrote in message
...
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."

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

"Bob Phillips" wrote:

IS your calculation mode set to manual, ToolsOptionsCalculation?

--
HTH

Bob

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

"New2Macros" wrote in message
...
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."

Check this list:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"New2Macros" wrote in message ...
| 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."

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)

"Niek Otten" wrote in message
...
Check this list:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"New2Macros" wrote in message
...
| 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."