Links (97 sr2)

Topic

New Reply

I have Excel 97 and have not been able to break links. I noticed that in Excel XP there is a facility to break links.
Is it possible to break the links within Excel 97

Reply | Quote

Replies

I have found that the easiest way is to just copy and paste the items back as a value. Links are gone then.

Dennis

Reply | Quote

Unwanted links can be problematic. To the best of my knowledge, there is no automatic method of breaking links in Excel 97. Microsoft recommends changing the link source to the current workbook, an approach that has worked for me in the past.

Also Post 30606 contains information about unwanted links and it also contains links (pardon the pun) to two utilities that deal with unwanted links.

HTH…

Reply | Quote

Another, less well known utility to list or break links is the one I wrote: “Locate Links”.
It creates a list of all links and provides options to delete them one by one or all at once.
Very simple to use. It is an Excel 97 (or later) Add-in and comes with instructions on how to install the Add-in.
If interested, I will Email it. (124KB)
The attached word document contains the instructions.

Jim Cone
San Jose, CA

Reply | Quote

Hi Jim,

I thank you for your advise and would like to receive your attachment for breaking the Excel Links.

Regards

David

Reply | Quote

You might also consider downloading FINDLINK.zip from the Excel MVP page listed below.

Reply | Quote