cannot use formula to link to another sheet
 

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

cannot use formula to link to another sheet
 

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

cannot use formula to link to another sheet
 

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

cannot use formula to link to another sheet
 

=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

cannot use formula to link to another sheet
 

I couldn't duplicate it either.

But another option that may work for you until you determine the solution....

select the "sending" cell
edit|copy
select the "receiving" cell
edit|paste special|paste link



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



--

Dave Peterson