Delete Links

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

Hi, I have a large workbook which claims that inside it somewhere tha
there is an external link to another file, I have searched all over i
and can't find it. It isnt entered in any cells and so I think that i
must be a macro that is trying to be pulled form another file.

Can anyone help me identify where this link is? And how to remove it?
 
Hi, I have a large workbook which claims that inside it somewhere
that
there is an external link to another file, I have searched all over it
and can't find it. It isnt entered in any cells and so I think that it
must be a macro that is trying to be pulled form another file.

Can anyone help me identify where this link is? And how to remove it?!
Click to expand...

Hi
maybe the following add-in will help you:
http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip

use this add-in to identify and remove your links


Frank
 
Ian,

It could also be a workbook name, have you looked there.

In VBA, as with a spreadsheet, the file is usually id'ed with a !. Do a
search through the whole workbook for that character.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top