=Sheet2!B1 manually entered in Sheet1!A1 works OK but when you type an = sign in
Sheet1A1 then point to Sheet2!B1 it does not.

Sheet2!A1 receives the formula and Sheet1!A1 is blank?

I cannot replicate this but perhaps another reader will have an idea.

I tried changing Transition options to Lotus mode and still could not replicate.


Gord

On Tue, 14 Aug 2007 08:28:01 -0700, Robindotadams
wrote:

Excel 2003

If I have 2 sheets, called "sheet1" and "sheet2".

In Cell A1 of sheet1 I type "+" and then use the mouse to click on sheet2
tab and cell B1 then "enter", the formula appears in sheet 2 cell A1, not
where I started it (Sheet1:A1). If I type the full formula in it works, but
I can't "select a cell on a different sheet with the mouse" as it then moves
the entire formula to that sheet!!!

"Gord Dibben" wrote:

Which version of Excel and how are you creating the link?

Typing the link in or pointing to the other sheet?

What would be a typical formula that exhibits this behaviour?


Gord Dibben MS Excel MVP


On Tue, 14 Aug 2007 06:44:01 -0700, Robindotadams
wrote:

Everytime I create a link in one sheet of excel to another sheet, it
overwrites the address with the sheet I am currently in (creating a circular
reference most of the time)... I think it's either an excel bug (never had
this before in 10 or so years of using excel) or a setting I've not seen
before... help please