Problems with copying cell values between worksheets

[Bill Osborne]

Has somebody seen this weird issue in Excel? I can
normally copy a cell's value from one worksheet to another
with the cell's formula keeping track of where it came
from. All of a sudden I can't copy a cell's, or a number
of cell's value(s) to some portions of the worksheet I'm
copying to. The cell only shows the prior cell's
coordinates but no value. I can find nothing odd in the
formating or anything. This is really fouling things
up...any ideas anyone?

Thanks ahead of time.