J JacobFI Oct 23, 2003 #1 How can I identify all linked cells in a document. Is thera way to locate, highlight, list or any other means? Thanks
How can I identify all linked cells in a document. Is thera way to locate, highlight, list or any other means? Thanks
G Guest Oct 23, 2003 #2 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
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
K Kevin Stecyk Oct 23, 2003 #3 JacobFI, http://www.bmsltd.co.uk/MVP/MVPPage.asp Look under Bill Manville and he has a utility that will help you. Regards, Kevin
JacobFI, http://www.bmsltd.co.uk/MVP/MVPPage.asp Look under Bill Manville and he has a utility that will help you. Regards, Kevin
