Breaking Links ?

[Mel]

Hi, could someone please tell me how I break links or find out what cells
are linked to another source so that I can change them.

Every time I open a particular workbook it tells me " This workbook contains
links to other data sources" However the original workbook does not exist
any longer or is on an old computer so is not valid any longer.

Thank you for any help.

 

[Dave Peterson]

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

 

[its.a.scign]

There is a Links menu item in the Edit menu

I would use Bill Manville's FindLink program:http://www.oaltd.co.uk/MVP/Default.htm

 

[Dave Mills]

There is a Links menu item in the Edit menu

In Ex 2003 I typed "link" in the help search and the first one listed is "Find
links in a workbook"

 

[Mel]

I tried to find the link with the Find [ but it cannot be found.

Dave I tried the link http://www.oaltd.co.uk/MVP/Default.htm but would not
open?

Thanks
Mel

 

[Dave Peterson]

It looks as though that site is having trouble.

I'd wait a bit (whatever that means) and try again.

I tried to find the link with the Find [ but it cannot be found.

Dave I tried the link http://www.oaltd.co.uk/MVP/Default.htm but would not
open?

Thanks
Mel

Hi, could someone please tell me how I break links or find out what cells
are linked to another source so that I can change them.

Every time I open a particular workbook it tells me " This workbook
contains links to other data sources" However the original workbook does
not exist any longer or is on an old computer so is not valid any longer.

Thank you for any help.