Thank you VERY much. Do you know of any reason this would have changed to
manual by itself? I have not entered that area before.


"ShaneDevenshire" wrote:

Well the second problem sounds like calculation is set to Manual. Choose
Tools, Options, Calculations, Automatic.

I'm not sure what is happening in the first part of your question, please
show an example:

Cell A1 contains =B1 and B1 contains the text "Test", when A1 is copied to
A2, A2 contains the text Test but no formula?
--
Thanks,
Shane Devenshire


"Tom" wrote:

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?