Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    78

    Unanswered: Checking if any fields is linked to another

    I have excel file with 15 sheets

    Is there a way that I can check if any of the fields are linked to another field or sheet (without checking each field)?

    Thank you

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Go to Tools->Formula Audinting->Formula Auditing Mode (or use Ctl+`)

    This will show all the cell formulas in the cells, rather than the values.
    It's easier to scan that way, but you're still stuck with looking at every cell.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    This works for fields within a spreadsheet (not sure how it displays cross-worksheet dependencies):

    Tools/Formula Auditing/Trace Dependents
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    This works for fields within a spreadsheet (not sure how it displays cross-worksheet dependencies):

    Tools/Formula Auditing/Trace Dependents
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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