Copying worksheet from one workbook to another creates unbreakable links

[crocodilesareforwimps]

I copied a worksheet from one worksheet to another that has named ranges, charts, formulas, and pivot tables. After copying it I changed all the pivottables' data sources to the current document's version and removed the copied one (adds a 1 to the end of the data connection name), and I deleted all the duplicated named ranges from the copied file. None of the formulas have retained any links to the original file from what I can see, and searching for "[" doesn't come up with anything. When I go to edit links, there is a new link which will not go away when you click "Break Link" and you can't change source. The only way I see to get rid of it is to delete the worksheet, which is obviously not an option. Where are these ghost links and how do I get rid of them?

Using Excel 2010

 

[Steeviee]

Not sure if this will help but it's worth a go!

Where you have changed the name ranges, do it again in every tab. there are sometimes more than one range with the same name but you can't see it unless you are physically in each sheet.
HTH

 

[crocodilesareforwimps]

No, the problem is clearly with this particular copied sheet. IF you delete the sheet completely, the link disappears. And the named ranges are the same on every sheet.

 

[Steeviee]

Why can't you change the source? Is there some protection on the worksheet or workbook?

Sorry not much help.

 

[crocodilesareforwimps]

When I change source, it shows the regular messages, but it doesn't actually change anything.