Cell Reference updating

I have created a excel file and in it there is a *** that is copied each
month and then it data is filled in during the month, the data is charted as
it's entered, and all is well. This same excel file is in use on a different
computer. The file was originally created with excel 97-2003 and updated to
2007 on both computers (stand alones).

On one computer, when the page is copied, the cell references automatically
update to reflect the new *** name, which is what we want.

On the other, they do not. The cell references remain the original ***.

I've checked all options, and they are the same.

What am I missing? What do I need to do to the second computer so the cell
references DO automatically update?

.