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

G

Guest

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?
 
E

Excelenator

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.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top