Suggestion #1: Don't do it that way. Only ever modify your data in one place or
eventually you'll shoot yourself in the foot. Particularly as your circular
references become complex extending through multiple cells and you forget
they're there even. Design your workbook in such a way as to not require this.

Suggestion #2: If you're driven to do this, you can enable circular references
with ToolsOptionsCalculation. Check the Iteration box. There's a very good
reason not to do this though.

Bill
---------------------------------
R.Hocking wrote:
Hi all,

I've come up against a problem with referencing between two sheets in
one workbook. The situation is as follows:

On sheet1, I have a complete list of data. This is displayed in a
different visual format on Sheet2. I have it set up so far so that, for
example, if I enter / alter data in cell A1 on Sheet1, Sheet2
automatically enters / alters the data in a corresponding cell.
However, on some occasions, I may want to alter the data in Sheet2 and
have Sheet1 update the equivalent cell! This seems to cause problems!
Does anyone have any suggestions as to a way round this?!

Thanks in advance,

Richard.