Breaking Links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Duncan - 25 Apr 2004 11:57 GMT

I have been developing a workbook in excel 2000 and have somehow
managed to link a data workbook to the display file. I need to break
this link as other people using the display workbook will not have
access to the data files.

In building the new display workbook I have copied and special pasted
values into the new work book as I go. There are no direct references
to any cells in the data workbook. I have no idea where the link(s)
are but need to get rid of them.

Any help much appreciated.

Reply to this Message

Frank Kabel - 25 Apr 2004 12:26 GMT

Hi
try the following add-in to find/delete these links:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I have been developing a workbook in excel 2000 and have somehow
> managed to link a data workbook to the display file. I need to break
[quoted text clipped - 7 lines]
>
> Any help much appreciated.

Reply to this Message

Duncan - 26 Apr 2004 09:32 GMT

Thanks for the info.

I actually found the offending link by going through the checks detailed in

http://j-walk.com/ss/excel/usertips/tip054.htm

Panic over :-))

> Hi
> try the following add-in to find/delete these links:
[quoted text clipped - 16 lines]
> >
> > Any help much appreciated.

Reply to this Message

David McRitchie - 27 Apr 2004 21:12 GMT

Thanks for the feedback. Do keep Bill Manville's link at
Stephen Bullen's MVP page handy because sooner or later
you will need it. Though I think I would use this link to read
about FINDLINK first, rather than going straight for the download.
http://www.bmsltd.ie/mvp/

"Duncan" <duncan_MacKinnon@standardlife.com> wrote in message ...

> Thanks for the info.
> I actually found the offending link by going through the checks detailed in
[quoted text clipped - 3 lines]
> > try the following add-in to find/delete these links:
> > http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

Reply to this Message

Marie Claire - 18 Jun 2004 14:27 GMT

I tried this website too and found the solution - phew!
Thanks!

MC

>-----Original Message-----
>Thanks for the info.
[quoted text clipped - 26 lines]
>> > Any help much appreciated.
>.

Reply to this Message

Marie Claire - 18 Jun 2004 10:36 GMT

Hi Frank,

I have a similar problem to Duncan so I have downloaded
the add in you recommended, however once I open it nothing
seems to happen! Can you give any further instructions
please?! (Apologies for being so dense!)

Thanks,

Marie Claire

>-----Original Message-----
>Hi
[quoted text clipped - 19 lines]
>
>.

Reply to this Message

Bill Manville - 19 Jun 2004 01:46 GMT

> Can you give any further instructions
> please?!

With the workbook containing the links active, use Tools / Find Links

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message