Hi,
I'm hoping this is a quick fix, a stupid question. I've been using excel since it first came out so I am stumped because I have never had this problem before.

I have two different excel files open. In file SampleA, cell A1, I type "=", then click on cell A3 in the other file SampleB, and it pulls the data from SampleB into the cell in SampleA. Like it always does, always has.

However, if I try to edit the formula which is in SampleA "=[SampleB.xls]Sheet1!$A$3"

either to remove the absolute reference, or change the cell reference, or even just click in the cell and hit enter, the cell in SampleA no longer displays the data from SampleB, it just displays the formula.

It is driving me crazy. Help.
Thanks