Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysterious Circular Reference Randy Ingle Excel Discussion (Misc queries) 0 July 4th 06 08:54 PM
Circular reference toolbar not working [email protected] Excel Discussion (Misc queries) 3 May 29th 06 01:55 AM
Circular Reference nastech Excel Discussion (Misc queries) 1 April 27th 06 12:54 AM
goal seek circular reference etxrmm Excel Discussion (Misc queries) 0 March 16th 06 09:56 AM
Circular Reference... Help! Bhupinder Rayat Excel Worksheet Functions 3 January 13th 06 05:10 PM


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"