Chart being "linked"

[Wil Moosa]

I copied a chart to a new workbook. I changed the range of the chart. After re-opening the workbook I get this message that data is linked and if I want to update.

How can I un-link the new workbook with the original workbook?

 

[Andrew Poulsom]

Choose Insert|Name|Define from the menu. Select each name and delete any which refer to your original workbook.

If that doesn't remove the Links, choose Edit|Links, select the file, click Change Source and browse for your current workbook.

 

[Jon Peltier]

Hi Wil -

A few questions. Chart sheet or embedded chart? How did you copy the chart? How did you change the chart range?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

 

[Wil Moosa]

Choose Insert|Name|Define from the menu. Select each name and delete any which refer to your original workbook.

That did it! Thanks.