Computing.Net > Forums > Office Software > Tracking links in Excel worksheets

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Tracking links in Excel worksheets

Reply to Message Icon

Name: uhjb
Date: April 22, 2009 at 08:43:06 Pacific
OS: Windows XP
Subcategory: Microsoft Office
Comment:

If I had linked let's say, B2 on Sheet2 (=Sheet1!A1) and C3 on Sheet3 (=Sheet1!A1) to A1 on Sheet1. Is there anyway I can find out from A1 on Sheet1 where all the cells it has links to? Very often I have links like this to many different worksheets. It would be nice to find out from Sheet1 all the sheets and cells it has links to. TIA.



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: April 22, 2009 at 08:55:01 Pacific
Reply:

Click on Sheet1!A1

Pull Down Tools...Formula Auditing...Trace Dependents

Since your dependents are on other sheets, you should get a black arrow ending in a "spreadsheet icon".

Double click the black arrow to get a list of dependent cells.

To remove the arrows, go back into Tools...Formula Auditing and choose Remove All Arrows.


0

Response Number 2
Name: uhjb
Date: April 22, 2009 at 09:23:53 Pacific
Reply:

Thank you very much for your help. That's exactly what I was looking for. Thanks again.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Tracking links in Excel worksheets

Mystery email address link in excel www.computing.net/answers/office/mystery-email-address-link-in-excel/8344.html

Creating e-mail link in excel www.computing.net/answers/office/creating-email-link-in-excel/1955.html

link to excel worksheet www.computing.net/answers/office/link-to-excel-worksheet/7676.html