Download and use Bill Manville's FindLink add-in.
http://www.oaltd.co.uk/MVP/Default.htm
Gord Dibben MS Excel MVP
On Tue, 6 Nov 2007 16:17:20 -0700, "Gary" wrote:
How can i find all the cells in a sheet that have links to other data
sources apart from that particular workbook?
Thanks in advance
Gary