Hi Tom

Sounds as though ToolsoptionsCalculation has been set to Manual for
that workbook.
Change it to Automatic

--
Regards

Roger Govier


"Tom" wrote in message
...
All of a sudden the existing formulas do not work in my worksheets. If
I copy
a cell and paste to another cell, it just paste's the value of the
copied
cell and not the formula. Or if it copies the formula, it show's the
right
cells to reference but the value is the copied cell value. If I open
a new
workbook, this does not happen and everything is fine.
Any suggistions?