Having a problem I've never seen, and can't figure it out. In Cell A1 I have
some text (assume it is "boy"). In Cell A2 I want to reference the value in
A1, so when A1 changes, A2 changes along with it. In Cell A2 I have the
formula "=A1". Instead of returning "boy" in A2, it just shows =A1 in the
cell, and doesn't catch the link. I've tried to force calc and have ensured
calculation is set to auto, cell still just shows =A1. Any ideas? Thanks.