Help me find a circular reference cells located in unknown multita

When I open my xls file (2003) I keep getting a circular reference error 
message. 
I can't find the cell among the numerous sheets. 
?
Also I found it once & checked it using the precedents button & it looked 
alright but I keep getting the error. Is the circular reference error message 
always always right ?
0
Utf
4/29/2010 11:55:01 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
483 Views

Similar Articles

[PageSpeed] 17

You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

John7100 wrote:
> 
> When I open my xls file (2003) I keep getting a circular reference error
> message.
> I can't find the cell among the numerous sheets.
> ?
> Also I found it once & checked it using the precedents button & it looked
> alright but I keep getting the error. Is the circular reference error message
> always always right ?

-- 

Dave Peterson
0
Dave
4/30/2010 12:31:32 AM
Click through you Worksheets while looking at the Status Bar. The cell 
address will appear on it when you activate the problem sheet.



-- 
Regards
Dave Hawley
www.ozgrid.com
"John7100" <John7100@discussions.microsoft.com> wrote in message 
news:BA37DAE9-D91B-4054-B7EF-C96DE2A3ECDD@microsoft.com...
> When I open my xls file (2003) I keep getting a circular reference error
> message.
> I can't find the cell among the numerous sheets.
> ?
> Also I found it once & checked it using the precedents button & it looked
> alright but I keep getting the error. Is the circular reference error 
> message
> always always right ? 

0
ozgrid
4/30/2010 12:55:51 AM
Reply:

Similar Artilces:

SKU119.CAB for Publisher 2002 Help
I have msiplaced my installation CD...I have my product ID and Version number close by....but, can't access my publisher files for some reason. Says I don't have access because the program is not intalled for current user. I am the only user on this computer. And somehow....I just can't get in now. Can someone help me find it...email the file to me...or something? Ric S EventDyn@aol.com Thank you Have you tried to do a repair? -- JoAnn Paules MVP Microsoft [Publisher] "EventDyn" <EventDyn@discussions.microsoft.com> wrote in message news:6545BA3A-185D...

HELP
help need to use statement expense in excel ...

CISCO and MSExchange help needed
We need help with troubleshooting and resolving complex problems to ensure quality transmission service on the network; manage and maintaining and user accounts, maintaining and updating our system security plans on all platforms if anyone feels they can help us. We have sufficient budgets to pay for the right person. Thanks John. -- John D Allen. CEO & President. Leveridge Systems INC. ...

Help
Hi All, I'm posting out as I've been having some issues with 3 nearly identical clients ever since putting in SBS2008. They have proven very difficult to trace and resolve. Client 1 - SBS2008 new install, new domain etc on HPML110, 5 users Client 2 - SBS2008 migrated from SBS2003 via MS Migration on HPML150, 15 users with all new HP/WinXP workstations Client 3 - SBS2008 migrated from SBS2003 via Swing It! migration, on HP ML350G6, also about 15 users. All 3 have Sonicwall TZ series firewalls, HP gigabit switches, and use Windows XP and Office 2003. All use Exchange ...

IF STATEMENT HELP NEEDED!!!
I'm trying to create a spread sheet and don't know this program AT ALL! I'm a designer and math and art just don't mix... So, here are the equations... In cell X6 I enter: If C6>D6 then (C6-D6)*5 or If C6<D6 then (D6-C6)*10 But, if cell D6 is yellow --- Put 20 in cell X6 So, I need some sort of identifier in the equation saying whether the cell is yellow or not. I'm sure excel doesn't recognize "yellow" but there must be another way. I can put a letter with a number in that cell if necessary. I'm not sure this is making sence, but if anyon...

Shading on highlighted range of cells
This is going to be hard to explain but here it goes. I am using Excel 2007. I would like to darken the shading when I highlight a range of cells. The problem I am running into is some of the workbooks that I inhierted have data in the cells that are white. When I use Excel 2003 I could highlight a range of cell and the cells that had data (with text color as white) could be seen. With Excel 2007 this is not the case. So is there a way to change the shading when I select a range of cells? Any help would be appreciated. Thanks. ...

Need Help with log on
I have frontpage and have always edited my site using it, my computer crashed, we got a new one and installed frontpage again. In the past when I would go to edit my site a box would come up asking for my user name and password so I could connect to the host server (I think thas what it is called) Anyway now no box comes up at all and I do not seem to beable to edit anything. I have asked my web host and they can not help me. The site is up and working but I can not make changes. Sorry I do not understand much of the tech stuff. I had a lady who did this for me but she is no lon...

Help with 'Auto_Open' please...
SubThe first time I open my excel workbook, a macro automatically runs. Part of this macro eventually calls for the deleting of 'Sheet1' in the workbook. When the macro is finished running, I save the file. The second time I open the workbook, I want it to check to see if it contains a 'Sheet1'. If it does, 'Exit Sub', else do something else... I've pasted my VBA code below. Do you see anything wrong with it? Many thanks, Craig ---------------------------------- Private Sub Auto_Open() calcmod = Application.Calculation With Application ...

splitting non-merged cells?
Is there a way to split cells that were NOT previously merged? I want to make column B which is 80 pixels into 40 pixels and insert new column C which is equivalent ajacent to it -- Message posted from http://www.ExcelForum.com "eckaner >" <<eckaner.10sn9w@excelforum-nospam.com> wrote in message news:eckaner.10sn9w@excelforum-nospam.com... > Is there a way to split cells that were NOT previously merged? > > I want to make column B which is 80 pixels into 40 pixels and insert a > new column C which is equivalent ajacent to it. Just insert a new column C...

How do I link two cells as to allow me to change the value in eit.
I have two tabs. The one tab contains a complex model ("Model"), and the other is a control or summary ("Control") of key values and settings in the model. I want to be able to change the key values in either the "Model" tab, or "Control" tab. If I have the Model tab refer to the Control tab for these values, it gets really annoying to trace formulas. If I have the Control tab refer to values in the Model tab, it is annoying to have to go to the Model tab to change the value. I want to be able to look at the Control tab and be able to change ...

sub tot column to next blank cell when blank cell exists in both c
I have posted this again to hope that someone will give me further assistance - I "ticked" the last post because it did work and well, but I realised what I actually need is slightly different. I asked for some coding that would search for each blank cell in a column and subtotal below it until the next blank cell. Stefi gave me this: Sub stotal() > Range("S1").End(xlDown).Activate > Range("S" & ActiveCell.Row - 1).Activate > Do While ActiveCell.Row <> Range("S" & Rows.Count).End(xlUp).Row + 1 > ...

are multiple Hyperlink destinations, in one cell possible
e.g.: =HYPERLINK(webaddress1),HYPERLINK(webaddress2,"2") Trying to get 2 web pages, one for the money,,, if that works, occasionally need to open range of cells web links, right now set up as hyperlinks 1,2; then 3,4 (2 for the show, or is it one to get ready jk) a b c d - 1 2 3 4 No. Sorry. What you CAN do is make it LOOK like one cell by putting borders around them, and perhaps turning off displaying gridlines. (It's one for the money, honey.) ************ Anne Troy www.OfficeArticles.com "nastech" <nastech@discussions.microsoft.com&g...

Excel 2003 question about help menu
I use Excel 2003 OFF-LINE. I find myself extremely limited and frustrated with the "menu approach" that it uses as well as the set number of items it will display as the result of a keyword search. The main problem for me ATM is that I know that the functions are categorized into say eight categories, e.g., text, but I don't always remember all of them. In the past, a search in Help would return a list of those categories from which I could quickly and easily navigate around to doublecheck my understanding. Search results in Excel 2003 are erratic, and trying to find the list...

To Find Mail Box names in Exchange Server
Hi all, I would like to find the list of mailboxes in our exchange server. Is there any way to find the mailbox name list using Extended MAPI or should i go for any other API. Any suggestions on this will be highly appreciated. Thanx in advance, Regards, deena Single server? Easiest way would be to export list from Exchange System Manager. -- Bharat Suneja MVP - Exchange www.zenprise.com NEW blog location: www.exchangepedia.com/blog ---------------------------------------------- <tsgd84@gmail.com> wrote in message news:1156427829.128690.229380@h48g2000cwc.googlegroups.com... ...

Cell formatting 03-09-10
I installed excel on my Vista laptop and the formatting comes up different than my XP desktop. Upon further investigation, although the Version numbers are the same in About, the product number is different. The option for date does not even exist in the laptop and the input is inverted? WHY Excel uses the setting that the user specifies in the control panel (regional settings) for date order. So my bet is one is using a short date format in one order and the other pc is using a different order--like mdy or dmy. Walter wrote: > > I installed excel on my Vista lapto...

teredo tunneling psuedo-interface code 10??? affecting my usb now i cant download music onto my ipod help!!
so i just got an ipod and when i pluged it in it said that and ipod was detected but could not be......( i forgot the rest) please unplug and try agian and it dosent work . so then i downloaded tune up utilities and it said i had 3 errors ,2 of wich really dont matter, but then i looked at the 3rd one and it said i had a code 10 on my teredo tunneling psuedo interface and it could not start. please help me!!!!! -- etfboy450 ------------------------------------------------------------------------ etfboy450's Profile: http://forums.techarena.in/members/169455.htm View this t...

trust help.
Hi all, We are going to create a two-way forest with CompanyB. The companyB has same internal and external public naming b.com. I just create the conditional forwarder for b.com to use their internal DNS server IPs. Now, when I ping b.com, it still routes to the external IP. Is this supposed to be? If I do nslookup b.com and it returns all their internal DNS IPs. Can I build a two-way forest trust or any additiona steps I need to configure? Thank you. If you are getting a different address when pinging and using NSLOOKUP on the same computer it is probably just the ...

Finding Font in Publisher 2002
I receive a warning that a font called "Enviro" is embedded in my doc. I can't find it anywhere, though, and have no idea where it came from. Does Publisher have a way to locate it in my doc? Thanks. After managing to set up OE-QuoteFix on his new PC, Ed reads a message from Jim Pearson <anonymous@discussions.microsoft.com>... > I receive a warning that a font called "Enviro" is > embedded in my doc. I can't find it anywhere, though, > and have no idea where it came from. Does Publisher have > a way to locate it in my doc? What version o...

Hyperlinks between two cells and referntially copying hyperlinks
Hi, I am a student teacher and am creating a workbook that links my timetable to class lists, and the individuals in the class to a seating plan, then back again. Manually linking each cell that refers to a pupil in the class list to a cell that indicates thier seating position (and back again) is too time consuming - 30 pupils per class, that 60 manual links. I thought I could make this somewhat easier by using the Hyperlink function so I could at least drag a series and part of the lnks would be created for me. I tried this: - =HYPERLINK("[Time Table Term 2 (revised).xls]9.1!C5...

Find maximum across multiple sheets
Hi all, I'm having alot of problems trying to summerize some data that I have on multiple sheets. I have set up a sheet called Cases that has an index of all the data sheets (i.e. 1, 2, ...) and would like to iterate through this list and find the maximum values and report them on my summary sheet. I would also like to report the sheet that has that maximum value. To complicate things a bit more, the ranges (i.e. 1!Data, 2!Data, 3!Data, ...) are defined as dynamic ranges. The structure and behaviour would look like something like this: SHEET: Summary item id | max value | max sheet 1 ...

Find out who closed a PO (and when)?
Is there a way to tell who closed a PO, and when it was closed? -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 Reports > System > General > Activity Tracking Detail Restrict based on a date range. Search through the entries. It should list in detail who closed the PO & the exact time they did it. "Bud" wrote: > Is there a way to tell who closed a PO, and when it was closed? > > -- > Bud Cool > Microsoft Certified Business Management Solutions Specialist, GP 9.0 &...

Network Adapter Name help.
Is there a way to get the Network name "Local Area Connection" beside reading it from registry? ...

Vlookup Table Help
Revisiting an eariler issue. I have an excel document that looks like what I've shown below, in Sheet 1 Column A Column B Column C Column D 1 Origin Airport Destination Airport City Name Airline 2 ABE 3 ABQ 4 ACE 5 ABI I am trying to create a Vlookup table that will decode the origin airport code in Col A and display the decoded code with the city name in Column D. In Sheet 2, my table array I have created looks like this. Column A Column B 1 Airport Codes City Code 2 ABE Abilene, TX, USA Municipal 3 ABQ Albuquerque, NM, USA Albuquerque International ...

Outlook 2000 Can't find contacts for Distribution list
In Outlook 2000 on Windows 98SE I have added contacts and want to create a distribution list I go File->New->Distribution list Then click Select Members. In the drop down list box next to the text "Show names from the:" there is nothing!! I expect to be able to set it to the Contacts folder but when I open the list box nothing is there. Any ideas? Thanks jw Is the Contacts Folder enabled as an email address book in its properties? -- Russ Valentine [MVP-Outlook] "MS" <yea@right.off> wrote in message news:%23$vfCi4DFHA.624@TK2MSFTNGP15.phx.gbl... > ...

Can not receive Email.. Need Help
Hi all, Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just stopped receiving external e-mail. We can send interoffice e-mails and we can send out e-mails to other locations fine, but we are unable to receive any e-mail. All internet connections are normal as well, and the port 25 is open on the firewall. The error from when we try to send an e-mail to the server is this: “This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed.” Earlier today I installed the anti-spam update from MS “Microsoft excha...