Your correct - that is the behavior in Excel 2003. It is not the behavior
in Excel 97. These are the two versions I tested. So I suspect not.
However, as to the correct value, obviously it is what is shown in the cell
as, as you have said, it doesn't change.


--
Regards,
Tom Ogilvy

"Julie" wrote in message
...
Hi Tom,

Thank you for your response. I have try it. The link cell will not change
value and message will said the cell you are trying to change is
protected.

This will not change link cell value, but however, the option button will
change.
Now the option button and the link cell are not in line. This will create
problem for me to know which is the right result.

Do you have any clue how to solve this?

Hope to hear from you again.

Best regards,
Julie