View Full Version : Checking if any fields is linked to another


myhnews
01-20-2006, 06:56 AM
I have excel file with 15 sheets

Is there a way that I can check if any of the fields are linked to another field or sheet (without checking each field)?

Thank you

qafself
01-20-2006, 09:31 AM
Hi,

Use TOOLS - auditing - trace dependents or precedents.

This will show all linked fields - can be a bit of nightmare if there are a lot but at least you have a starting point!

Ed

shades
01-20-2006, 09:32 AM
Or go to EDIT > LINKS and see what and where they are located.