A couple things to test:

If you press the [F9] key to calculate the workbook, do the correct values
display?

If you edit one of the copied cells and press the [F9] key to calculate it,
does it show the correct value?
(don't press [enter] after doing that or you'll hard-code the value)


***********
Regards,
Ron

XL2002, WinXP


"Marilyn" wrote:

Ron,

as previously posted I checked to ensure that the Calculation was set to
Automatic and it is. The formulas do not have any errors because when I
close the file and re-open the formulas change to their correct values.

Any ideas?

"Ron Coderre" wrote:

The usual reason for that problem is that Excel calculation is set to manual.

Try this:

From the Excel main menu:
<tools<options<calculation tab
CHECK: Automatic calculation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Marilyn" wrote:

I'm working on a workbook that is accessible to my co-workers on a share
drive. When I copy formulas down the results remain the same as the original
formula or they display Zero. The cell reference is changing accordingly,
but the result is not changing.
I checked the Calculation mode and it is set to Automatic.

Has anyone seen this error before?

Thanks,