Share via

Trace Dependents not showing dependents on different sheet

Anonymous
2021-01-30T02:10:58+00:00

I am using Excel for Mac v16.45

I am attempting to ensure that a number of cells are used in exactly one other formula. I would have expected to be able to select a range of cells and then ‘Trace Dependents’, then for each cell (with a dependent on another sheet in the same workbook) to be able to click on the icon/arrow/dashed line to see a dialog box with a list of (hopefully one) cell.

There are two problems.

The first is merely annoying and has a workaround - the Trace Dependents command only works on the first cell, no others in the range.

The second is extremely frustrating. No matter where I click (apart from one attempt out of possibly 100) I cannot get the mouse click to be detected in the icon/arrow/dashed line - it always detects the click as if the icon/arrow/dashed line is not there and selects the cell behind.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 430.5K Reputation points
    2021-01-31T15:39:20+00:00

    As I wrote... "...anywhere on the Precedent/Dependent arrow.". You don't have to click on the arrowhead.

    1 person found this answer helpful.
    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2021-01-31T17:36:47+00:00

    Hi Chris,

    In bygone versions of Excel you would click the little icon. In current Excel you click the dotted part of the arrow - anywhere on the dotted line, as Bob pointed out. The line is very thin and you will have to carefully hover the mouse over the line to click it.

    8 people found this answer helpful.
    0 comments