Tools|Options|Calculate
If Manual is checked, change it to Automatic.

Jerry

Tracey BVS wrote:

When I drag and drop a formula it is copying the cells only and not the
result, however when I go into the cell and press enter the result is
correct.