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