Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tracking down dependent cells 1

Status
Not open for further replies.
macajm

macajm

Mining
Jun 5, 2001
26
Does anyone know how to find dependent cells after using the "Trace dependents" button on the Auditing toolbar, when the dependent cells are in another worksheet? (It's fine if they are on the current worksheet, as Excel shows arrows, but if on another sheet, just an icon appears)
 
Replies continue below

Recommended for you

Sort by date Sort by votes
I've never messed around with this before, but I tried it to see. I got an arrow from the source cell pointing to a little spreadsheet looking icon. I found that in double-clicking the arrow (arrowhead or end dot or line in between) a GOTO dialog opens giving you the path to the dependent cell.

Hope this helps.
 
Upvote 0 Downvote
Thanks ProjEngKLS - That's the trick I was looking for.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dik
  • Locked
  • Question
Copying Cells 2
Replies
6
Views
834
dik
dik
jmarkus
  • Locked
  • Question
MS Excel - Drop Down Lists that result in links to original list cells 4
2
Replies
33
Views
834
SkipVought
SkipVought
JG2828
  • Locked
  • Question
Excel file with "ghost" data in cells 1
Replies
12
Views
794
JG2828
JG2828
Trenno
  • Locked
  • Question
Merging Unique Cells Into Unified Headings
Replies
13
Views
502
SkipVought
SkipVought
eit09
  • Locked
  • Question
Macro error when cells locked
Replies
4
Views
263
eit09
eit09

Part and Inventory Search

Sponsor

Back
Top Bottom