>.
>
The links are probably in defined names.
Assuming you have got rid of all formulas in the workbook then the
names are probably not useful either.
Sub DeleteLinkedNames()
Dim N As Name
For Each N In ActiveWorkbook.Names
If InStr(LCase(N.RefersTo),".xls")>0 Then N.Delete
Next
End Sub
If that still leaves you with links, try finding them with FINDLINK.XLA
from http://BMSLtd.co.uk/mvp and then you'll know what else needs to
be deleted from the workbook
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
~ Moe (Boston)
>.
>
There is a "delete links" wizard in the Knowledge Base...
it downloads the file dellinks.exe. It works well for me.
Aimee
>.
>
Have a look at Navigator Utilities - and Excel add-in which will show you
exactly where the remaining links are. For each external workbook, it will
show you all the links to that workbook.
Another utility within the add-in allows you to replace all formulae in
selected sheets with values with a single click. This is great for removing
formulae before sending out to clients.
Navigator Utilities is a free download at www.robbo.com.au
regards
Mark
"Paul" <hagne...@johndeere.com> wrote in message
news:06fe01c2cb96$79ee79c0$d5f82ecf@TK2MSFTNGXA12...