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