Circular Reference Error Even Though There Is No C.R.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MDW - 25 Jul 2006 18:51 GMT

Some of my colleagues are getting "circular reference" errors upon opening
some Excel (2003) workbooks. I can open those same workbooks (also using
Excel 2003) and I have no problem.

The cell being identified as having a c.r. has the following formula:
=sheet2!L16

The cell sheet2!L16 has the following formula:
=+'T:\Folder\[external_file.xls]summary_report'!M41

On the external file, cell M41 is a simple value with no fomulas or anything.

Any ideas what could be causing this problem?

Signature

Hmm...they have the Internet on COMPUTERS now!

Reply to this Message

Excelenator - 25 Jul 2006 19:42 GMT

Is it possible they have another workbook open that contains the
circular reference? The error message for circular references appears
as long as the workbook containing the CR is open even if you toggle to
another open workbook which would give the appearance that the workbook
you are viewing has the CR. Just a thought.

MDW Wrote:

> Some of my colleagues are getting "circular reference" errors upon
> opening
[quoted text clipped - 14 lines]
> --
> Hmm...they have the Internet on COMPUTERS now!

Signature

Excelenator

Reply to this Message