Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Auditing A Circular Reference (2000)

    I have a very large file (>1.65 MB) that I am trying to revise. However, in some cases when I try to do so, say change a formula in a cell that references another, Excel informs me I have created a circular reference. That is OK as long as I can "trace" the circular and attempt to remove the problem.
    I tried the auditing tool with the arrows, but it doesn't go far enough.
    Any ideas?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Auditing A Circular Reference (2000)

    Hi,

    If you click on the 'show precedents' icon multiple times, Excel will extend the range of precedents traced by one level each time.

    You may need to be careful about how you use this, or you could end up with a screen full of precedent arrows. One way of avoiding that might be to click on the 'show precedents' icon once for the first problem cell and then, if it references multiple cells, track precedent cell in turn, by selecting it and clicking on the 'show precedents' icon again, tracing all it's precedents in turn. Note that, with a large workbook, this could be quite time consuming.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Auditing A Circular Reference (2000)

    Mac,
    Been there...done that!
    Thanks anyway,
    Jeff

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Auditing A Circular Reference (2000)

    Jan,
    Thanks for the link-I'll try it!
    Jeff

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auditing A Circular Reference (2000)

    <P ID="edit" class=small>(Edited by Leif on 13-Mar-04 17:04. to update link to http://www.bmsltd.ie/)</P>Go to Stephen Bullen's site and find a file called FINDCIRC.zip.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •