Finding dependancies between Sheets

Todd L

New Member
Joined
Dec 7, 2005
Messages
2
I have received a spread sheet that I need to reverse engineer (excuse me if I have chosen the wrong words) but I am not having any luck finding what is referencing a particular cell. I can use the dependancy 'button' but this doesn't help when the reference is on another sheet, it only tells me that there is a dependancy. Is there a way to find what cell(s) is referencing a particular cell even when it is on another sheet?
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Welcome to the board.

If you go to tools --> formula auditing --> trace dependents, Excel will show an arrow pointing to an icon of a spreadsheet if there is a dependent cell on another page. Try double clicking on the arrow for a list of dependents.
 

Todd L

New Member
Joined
Dec 7, 2005
Messages
2
Thank you,

I tried double clicking on the spreadsheet icon, it never occured to me to click on the arrow.

todd
 

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,251
Members
412,709
Latest member
Rishu
Top