Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an excel spreadsheet where the dependents are not showing offsheet dependents when using the trace dependents option. This feature works fine in all other worksheets in the workbook. has anybody seen this problem before, and how did you fix it?
3 replies
by parier
In Microsoft Excel 97, you can use auditing arrows to trace dependents, precedents, and errors. To use auditing arrows, do the following:
Select the cell you want to audit.
On the Tools menu, point to Auditing, and then click Trace Precedents, Trace Dependents, or Trace Error, as appropriate.
If you click Show Auditing Toolbar, you can use the tools on the Auditing toolbar to audit cells.
Hope this helps.
Poster rated this answer
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies