I am looking for cells in a workbook that contribute to a link in a different
workbook.
(your second answer, I believe)

"Dave Peterson" wrote:

If you mean you're looking for formulas that are retrieving values from other
workbooks, you could use Edit|find and look through formulas for things like
".xls". But I find using Bill Manville's FindLink program much easier:
http://www.oaltd.co.uk/MVP/Default.htm

But if you meant you're looking for all the workbooks that have formulas that
link to a specific workbook (your workbook is "sending" the data), then I don't
think that there's a good way to find all those possible workbooks.

You could open each possible "receiving" workbook and look, but that only works
if you can at least limit the number of workbooks to search.

ChristyR wrote:

How can I find what cells are being linked in a source workbook?

--

Dave Peterson