Formulas Not Working
 

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

Formulas Not Working
 

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

Formulas Not Working
 

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

Formulas Not Working
 

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

Formulas Not Working
 

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