FInding external link

[Fred Smith]

When I open a spreadsheet, I get asked if I want to update external links. There
shouldn't be external links in this spreadsheet, so I must have accidentally
left in a formula which I need to change to a value. But I can't find the
offending cell.

How do I search for a formula with an external link in it?

 

[Norman Jones]

Hi Fred,


Try Bill Manville's FindLinks addin which is freely downloadable at:

http://www.oaltd.co.uk/MVP/Default.htm