The default on the setting is Automatic. Maybe another user set it to
manual? If there are any macros in the workbook, they may have set the
option. When I write macros I often have them set this option to manual
because the macros run faster in many cases, however, the author of the macro
must make sure that they turn the option back on in the code.
--
Cheers,
Shane Devenshire


"Tom" wrote:

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?