Tracking links in Excel worksheets

April 22, 2009 at 08:43:06
Specs: Windows XP
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.

See More: Tracking links in Excel worksheets

Report •

April 22, 2009 at 08:55:01
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.

Report •

April 22, 2009 at 09:23:53
Thank you very much for your help. That's exactly what I was looking for. Thanks again.

Report •

Related Solutions

Ask Question