Help please with formulae!!!

[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

 

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

 

[Frank Kabel]

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

Regards
Frank

 

[Andy B]

Hi

Make sure that calculation is set to automatic (Tools / Options /
Calculation)

 

[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