Thank you! I did not even notice about being in manual mode...

Hernan

"Gord Dibben" wrote:

The formulas in the protected cells will update as you enter new data so no need
to unprotect.

Are you having an issue with the formulas not updating?

Maybe you have calculation mode set to manual?


Gord Dibben MS Excel MVP

On Sat, 27 Oct 2007 08:06:01 -0700, Hernan
wrote:

i hope I am posting in the correct forum.

I have a sheet in which I have 4 areas to enter data and at the end of each
area the rows and columns have running totals.

How do I protect and unprotect the sheet in order to update the cells that
carry the running total after each input is done?

Thanks in advanced.

Hernan.