OMG! Too simple. You're a prince, Jon!

"Jon Peltier" wrote:

Go to Edit menu Links, find the other workbook in the list and select the
link, click Change Link, and browse to the file you have open,

Next time, copy the charts using this approach:
http://peltiertech.com/WordPress/mak...k-to-new-data/

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Janie" wrote in message
...
Have mulitple charts. Source Data is :

='[different file]!sheet name'!range.

The sheet from the different file has now been copied into the file where
charts are. Is there an easy way to remove the different file name from
all
the Source Data references (for Name, XValues and Values) such that
reference
becomes simply:

='sheet name'!range