If excel thinks you have a circular reference, I bet dollar to doughnuts you do!

And my guess is that the reason your technique fails is that you have each of
the workbooks open in separate instances of excel.

Close one of the instances.
In the remaining open instance, use File|Open to open the second workbook
Then try creating the link.

cwkek wrote:

I'm unable to link cells between different workbooks and worksheets, I hope
somebody can help me with this as the linking worked fine before this problem
appeared. However, linking within the worksheet is ok. I get either a
circular reference message (even when there is no circular reference) or the
cursor appears in another cell in the worksheet that I'm trying to
reference/link to. Is there some setting that I've accidentally changed?
thanks!

--

Dave Peterson