Problem breaking a link
 

I copied a worksheet from one spreadsheet to another. All the formulas had
to be changed to refer to the new spreadsheet - no problem

In Edit Links it still showed that there were links to the old (original)
spreadsheet - on choosing the Break Link command, I answer Yes to the Are you
sure? question, but the links are not broken - it still shows as being linked
to the old spreadsheet

Any suggestions

Bill Manville's FindLink addin may help you find the hard to find links:
http://www.oaltd.co.uk/MVP/Default.htm

TJB wrote:

I copied a worksheet from one spreadsheet to another. All the formulas had
to be changed to refer to the new spreadsheet - no problem

In Edit Links it still showed that there were links to the old (original)
spreadsheet - on choosing the Break Link command, I answer Yes to the Are you
sure? question, but the links are not broken - it still shows as being linked
to the old spreadsheet

Any suggestions

--

Dave Peterson