Removing Links from with a Large Workbook

[Robert Harris]

Excel 2000

I have a large workbook with many sheets that has evolved
over time, and includes a lot of embedded links to other
workbooks.

I want to clean the spreadsheet up and remove the links.

First I need to find out which cells in the spreadsheet
are linked to external sources.

It is going to be a very tedious exercise if I turn on
Tools|Options|View|Formulas, and go through the entire
workbook cell by cell.

The Edit|Links menu selection doesn't provide a quick way
(that I can see) if which cells in the active workbook
are linked to external sources.

Does anybody know a quick way to identify all cells in a
workbook that are linked to an external source?

Thanks in advance,

Robert

 

[Frank Kabel]

Hi Robert,

try Bill Manville's utility Find Link. Can be found on the following
site
http://www.bmsltd.ie/MVP/Default.htm

Frank