Excel 2000

JacobFI · Oct 23, 2003

How can I identify all linked cells in a document.

Is thera way to locate, highlight, list or any other means?

Thanks

Guest · Oct 23, 2003

There is no automatic way to find links used in a
document. But since links use brackets [ ] to enclose the
source name, you can search for it.

For example =COUNT([workbookname.xls]Sheet1!C1:C25).

HTH,
BC

Kevin Stecyk · Oct 23, 2003

JacobFI,

http://www.bmsltd.co.uk/MVP/MVPPage.asp

Look under Bill Manville and he has a utility that will help you.

Regards,
Kevin

Excel 2000

JacobFI

Guest

Kevin Stecyk