Removing dead Link
 

I've got my own *simple* problem

Somehow my workbook thinks there is a link to temporary sheet I was using.
I can't work out a way to get rid of *the link*

Edit Links - tells me the file (which has gone), but won't let me delete
the link
nor tell me where it *thinks* it is.

--
Steve (3)

Removing dead Link
 

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

SteveW wrote:

I've got my own *simple* problem

Somehow my workbook thinks there is a link to temporary sheet I was using.
I can't work out a way to get rid of *the link*

Edit Links - tells me the file (which has gone), but won't let me delete
the link
nor tell me where it *thinks* it is.

--
Steve (3)

--

Dave Peterson

Removing dead Link
 

That worked fine, though object to 22 series in a chart
22 pairs of error message later.

It was a defined name, I deliberately used a name for the area I was
refereing to so that when I copied the sheet to a different workset I
could ensure the code, worked by setting/checking the defined name.

What caught me, and I didn't know until I deleted the names, was that each
name was defined twice, the first linking to the dead file invisible until
I deleted the 2nd name which of course was working fine

I cheked the names, thinking that might be an area of concern, but of
course couldn't see the 1st defined names

Bit naff, but thanks to your link - fixed

Steve


On Wed, 26 Jul 2006 16:22:52 +0100, Dave Peterson
wrote:


When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

SteveW wrote:

I've got my own *simple* problem

Somehow my workbook thinks there is a link to temporary sheet I was
using.
I can't work out a way to get rid of *the link*

Edit Links - tells me the file (which has gone), but won't let me delete
the link
nor tell me where it *thinks* it is.

Removing dead Link
 

Bill's program is a very nice one to keep--it looks for links in spots that I
wouldn't have even considered!

SteveW wrote:

That worked fine, though object to 22 series in a chart
22 pairs of error message later.

It was a defined name, I deliberately used a name for the area I was
refereing to so that when I copied the sheet to a different workset I
could ensure the code, worked by setting/checking the defined name.

What caught me, and I didn't know until I deleted the names, was that each
name was defined twice, the first linking to the dead file invisible until
I deleted the 2nd name which of course was working fine

I cheked the names, thinking that might be an area of concern, but of
course couldn't see the 1st defined names

Bit naff, but thanks to your link - fixed

Steve

On Wed, 26 Jul 2006 16:22:52 +0100, Dave Peterson
wrote:


When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

SteveW wrote:

I've got my own *simple* problem

Somehow my workbook thinks there is a link to temporary sheet I was
using.
I can't work out a way to get rid of *the link*

Edit Links - tells me the file (which has gone), but won't let me delete
the link
nor tell me where it *thinks* it is.

--

Dave Peterson