Help please with formulae!!!

J

Jen

I'm hoping someone can help me... all of a sudden my
excel worksheets won't copy formulae from one cell to the
next - only the value copies.
If I manually insert the formula for a total, any changes
within the data range are not reflected in the total.
Can you please help??
thank you
Jen
 
H

Harald Staff

Hi Jen

A sheet behaves like that if it's protected and the formula cells are marked
Locked and Hidden. Try unprotecting the sheet.
 
F

Frank Kabel

Hi
maybe automatic calculation is disabled. Goto 'Tools -
Options - calculate' and check 'automatic calculation'

Regards
Frank
 
R

Robert Christie

Hi Jen
If pressing F9 key calculates correct totals, could be
your automatic calculation is switched off, Goto Tools--
Options--Calculation and in Calculation area check
Automatic

HTH
Regards Bob Christie
 
Top