linked cells

[quixote]

I haven't used excel that much for complex functionality.
Usually use Access to create db's. I have an excel
workbook with a few sheets in it that someone has sent me.
Many of the cells are linked to other spreadsheets. Is
there a way for me to find out what cells are linked to
where? There are hundreds of cels and I don't want to go
through these individually.

Thanks,
quixote

 

[David]

Formula auditing toolbar will help.

 

[GJones]

Hi quixote;

Go to Tools / Formula Auditing / Trace Precedenents or
Trace Dependents

Thanks,

Greg