Removing automatic links

[Joey]

Hi all

I cut columns from one work book and pasted it in another. Now when
open it, a prompt states that it has automatic links and to eithe
click yes or no.

Is there a way of getting rid of this because I want to deleted the ol
workbook or am I stuck with it?


Many thanks guys
Joe

 

[Freemini]

The easiest way to find the links is to perform a search or a replace
If the cells contain formulas that refer to the original workbook an
need to refer to the current workbook you could try replacing th
workbook name with a blank replacement. This will only work if the ne
workbook has the same sheet names as the original.
Once you are happy that you have found all the links in the cells sav
the workbook and then check under Edit, Links to see if thee are stil
links. If there are they are probably held as names. To check this g
to Insert, Names, Define and delete any names which refer to othe
workbooks.

hth

Mik

 

[Joey]

Thanks Freemini

I'll give it a go..

Cheers
Joe

 

[Dave Peterson]

Get a copy of Bill Manville's FindLink program:
http://www.bmsltd.ie/MVP/Default.htm

It'll help you find those hard to find links.