I'm "pointing to" a cell in another worksheet. I should be able to hit "="
then click on the worksheet and cell I want, then hit enter. The value in
the referenced cell should now show in the new worksheet. Instead, I'm
seeing the address of the referenced cell.

Has anyone had this problem? Is there possibly something in the formatiing
of the two worksheets that's causing a problem?