Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular Reference Error Even Though There Is No C.R.
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 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? -- Hmm...they have the Internet on COMPUTERS now! -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=564830 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mysterious Circular Reference | Excel Discussion (Misc queries) | |||
Circular reference toolbar not working | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Discussion (Misc queries) | |||
goal seek circular reference | Excel Discussion (Misc queries) | |||
Circular Reference... Help! | Excel Worksheet Functions |