Removing dead Link

  • Thread starter Thread starter SteveW
  • Start date Start date
S

SteveW

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.
 
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
 
Bill's program is a very nice one to keep--it looks for links in spots that I
wouldn't have even considered!
 
Back
Top