trace dependents

  1. X

    On Excel, how can I tell which other worksheets dependents are on?

    When I click "Trace Dependents" for a cell on a given worksheet and the little arrow picture shows that it has dependents on other worksheets in the workbook, how can I find out exactly which other cells of which other worksheets are dependents of the original cell?
  2. J

    BUG re formula auditing with Tables (ListObjects): known to MS since 2007

    Cross-link: http://www.mrexcel.com/forum/general-excel-discussion-other-questions/954352-bug-re-formula-auditing-tables-listobjects-known-ms-since-2007-a.html I'm reporting a bug re formula auditing with Tables (ListObjects). Just follow these steps in Excel >=2007: 1.Start from a blank...
  3. J

    BUG re formula auditing with Tables (ListObjects): known to MS since 2007

    I'm reporting a bug re formula auditing with Tables (ListObjects). Just follow these steps in Excel >=2007: 1.Start from a blank workbook with at least two tabs. 2.Create a table (ListObject) with dummy data on one tab. 3.Create on another tab a formula that refers to the table data, e.g...
  4. K

    How t check "Trace Dependents" ?

    Hello dear excel lovers. I've a trial balance and financial statements linked to it. Trial balance consists of a lot of pages. I want to see if there is any value in trial balance which is not feeding the financial statements. Actually there are tons of items and it's hard to check that every...
  5. A

    Audit Tools Greyed Out (Trace Dependents, etc.) Excel 2007

    Hi All, Very frustrating problem: the trace audit tools in my worksheet are all greyed out for some reason (trace precedents, dependents). The worksheet is not protected. It does have probably a couple hundred Index/Match functions throughout the book. I've seen people give suggestions...
  6. J

    Suppress "Trace Dependents" pop-up in Excel 2007

    Whenever I try to trace the dependents on a cell that has no dependents, I get a pop-up that says "The Trace Dependents command found no formulas that refer to the active cell". Previous versions of Excel didn't have this popup. How can I suppress it? Thanks
  7. B

    Trace Dependents PLUS

    Does anyone know of a "trace dependents" option which will track all 'downstream' dependents for a particular cell? I am trying to debug a complex workbook where cause and effect can be separated by about 10 hops/sheets. I appreciate that this can be a long list and follow many different legs...

Some videos you may like

This Week's Hot Topics

Top