Excel formulas
 

I have a file that I protected with formulas in it. It used to automatically
sum the numbers but it stopped doing that. I have it so that people can add
a row and numbers and it worked fine for a while. Now I noticed that it
stopped doing that and at the bottom line where it says Ready, NUM, CAPS,
etc, it says Calculate. Can someone help so I don't have to keep on
unprotecting the sheet and redo the formulas?

Thanks,

Sue

ToolsOptionsCalculation. Sounds like it is set for "Manual"

Checkmark "Automatic".


Gord Dibben Excel MVP

On Tue, 10 May 2005 08:19:06 -0700, "SueK"
wrote:

I have a file that I protected with formulas in it. It used to automatically
sum the numbers but it stopped doing that. I have it so that people can add
a row and numbers and it worked fine for a while. Now I noticed that it
stopped doing that and at the bottom line where it says Ready, NUM, CAPS,
etc, it says Calculate. Can someone help so I don't have to keep on
unprotecting the sheet and redo the formulas?

Thanks,

Thank you!!

"Gord Dibben" wrote:

Sue

ToolsOptionsCalculation. Sounds like it is set for "Manual"

Checkmark "Automatic".


Gord Dibben Excel MVP

On Tue, 10 May 2005 08:19:06 -0700, "SueK"
wrote:

I have a file that I protected with formulas in it. It used to automatically
sum the numbers but it stopped doing that. I have it so that people can add
a row and numbers and it worked fine for a while. Now I noticed that it
stopped doing that and at the bottom line where it says Ready, NUM, CAPS,
etc, it says Calculate. Can someone help so I don't have to keep on
unprotecting the sheet and redo the formulas?

Thanks,