I have a value in Sheet1 Cell A1. I want the value to be repeated in Sheet2
Cell A1. In the past, I have clicked on the destination cell, entered =,
clicked on the source worksheet, then on the source cell, hit Enter, and the
destination cell was linked to the source cell.

However, this no longer seems to work in Excel 2003. I click on the
destination cell, enter =, click on the source worksheet, then the pointer
turns into a hand and I am not able to click on the source cell.

It seems to only be affecting two users that I am aware of. If they copy
the cell and paste the link it works, but they want to be able to click on
the cells to select them.

Anyone have an idea what would prevent them from being able to select a cell
for a link?