I couldn't duplicate this when I tried.

Maybe you didn't start with an equal sign?

How is the first cell formatted--General?

Is the other worksheet in the same workbook--or a different workbook?

If it's in a different workbook, do you have both workbooks open in the same
instance of excel?



Dave wrote:

I'm having a problem that I've never encountered in my 10+ years of using
Excel. If I begin to write a formula in a cell in Sheet1 and try to link it
to a cell in Sheet2, when I hit Enter the formula ends up entering itself not
in Sheet1 (where I started), but instead in Sheet2. I'm sure this is just a
setting I switched on somewhere. Does anyone know how to turn this off?

--
Dave

--

Dave Peterson