Formula Errors

Fix Excel Trace Dependents Not Showing Cells on Another Sheet

Camila Milosovich Oct 8, 2026 872 views

Question details

The user is unable to view or navigate to dependent cells located on a different worksheet using the Trace Dependents tool.

How to Fix Excel Trace Dependents Not Showing Cells on Another Sheet

Product: Excel
Device & OS: not provided
Scenario: Auditing formulas and tracing dependent cells that span across multiple worksheets.
Observed behavior: Clicking the sheet icon on the dotted dependency arrow produces no action, making it seem like cross-sheet dependent cells are not displayed.

Before you start

Verify that your selected cell is actually referenced by formulas on other worksheets, and ensure your workbook is not protected in a way that prevents formula auditing.

Solution 1Recommended

Double-Click the Dotted Dependency Line

Navigate to off-sheet dependents by double-clicking the active dotted line rather than single-clicking the sheet icon.

When tracing dependents across different worksheets, Excel generates a black dotted line pointing to a small worksheet icon. The icon itself is not the interactive element; the dotted line is. Interacting with it correctly will bring up the 'Go To' dialog.

Activate Trace Dependents

Select the cell you wish to audit. Navigate to the 'Formulas' tab on the ribbon and click 'Trace Dependents'.

Hover over the dotted line

Look for the black dotted line pointing to a sheet icon. Move your mouse pointer directly over the dotted line and wait for the pointer to change from a thick white cross to a standard selection arrow.

Double-click to open Go To dialog

Once the pointer is an arrow, double-click the dotted line. Do not click the sheet icon itself.

Navigate to the dependent cell

The 'Go To' dialog box will appear, listing all cross-sheet and external dependencies. Double-click the desired cell reference in the list to jump directly to it.

Pointer Shape is Crucial: If you double-click while the cursor is still a white cross, you will merely select the cell beneath the cursor. Ensure the cursor has changed to an arrow pointer before double-clicking.

Audit Formulas Easily

Use WPS Spreadsheet to Trace Formula Dependents

WPS Office provides a robust, easy-to-use Spreadsheet application that flawlessly handles complex cross-sheet formulas. Tracing dependents is visually clear, highly responsive, and 100% compatible with your existing Microsoft Excel workbooks.

1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your existing Excel workbook containing the cross-sheet formulas.
2. Access the Formulas tab: Select the cell you want to trace and click on the 'Formulas' tab located in the top menu ribbon.
3. Click Trace Dependents: Click the 'Trace Dependents' button to reveal the directional arrows.
4. Navigate to off-sheet cells: Double-click the dotted dependency arrow to open the Go To dialog and jump instantly to the dependent cell on the other worksheet.

Intuitive formula auditing tools including Trace Precedents and DependentsFully compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight architecture for fast calculation of complex formulasFree to download with a familiar user interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does nothing happen when I click the sheet icon?

The sheet icon at the end of the dotted dependency line is a visual indicator, not a clickable button. To navigate to the cross-sheet dependent cell, you must double-click the actual dotted line connecting your cell to the icon.

Does Trace Dependents work for external workbooks?

Yes, but the external workbook containing the dependent cell must be currently open in Excel. If it is open, double-clicking the dotted dependency arrow will list the external reference in the 'Go To' dialog.

How do I remove the dotted arrows after tracing?

Navigate to the 'Formulas' tab on the ribbon and click the 'Remove Arrows' button. You can also click the drop-down arrow next to it to selectively remove only dependent or precedent arrows.

Excel & Data Problems