Results 1 to 4 of 4
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trace values to different sheet (Excel 2000)

    Good Afternoon <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

    I have a wookbook that has multiple sheets. I am on one page that contains a series of assumptions and I wanted to trace where these assumptions are being used.

    I've tried the 'audit' toolbar and it just tells me that they are used on a different sheet.

    I've tried searching for the sheet name but nothing was found (does that search only cover the active sheet <img src=/S/question.gif border=0 alt=question width=15 height=15>)

    Is there anything else that I can try?
    Cheers,

    Tim
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trace values to different sheet (Excel 2000)

    Select the cells and then Tools/Auditing/Trace Dependants. You should get an arrow pointing from the cell to an Icon of a spreadsheet. This indicates that the cell is referenced on another sheet. The end of the arrow that is in the cell should have a round end on it. If you move the cursor over that round end it should turn from a cross to an arrow. Double click, and you should get a "GoTo" box that should list all of the referencing cells and allow you to click and go to them.
    Legare Coleman

  3. #3
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trace values to different sheet (Excel 2000)

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> you learn something new everyday.

    Thanks a lot.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Trace values to different sheet (Excel 2000)

    Legare,

    I always wondered how you did the tracing - never occurred to me to double click the round dot.

    Seems like it doesn't matter which end of the arrow you double click on - the round dot or the arrow head.

    fred

Posting Permissions

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