Joe Dawson


Does anyone know of how to generate a list of all of the cells and the respective sheet in which they exist in a workbook that point to other workbooks I have inherited an enormous spreadsheet and I want to get rid of unnecessary links to other workbooks that want refreshing when I open it

Joe



Re: Report links to other files

Andy Pope


Hi Joe,

Have a look at this free xla FindLink
http://www.oaltd.co.uk/MVP/Default.htm







Re: Report links to other files

Joe Dawson

Looks slick. Thanks Andy.

Joe