Cannot Update Chart Data Range!
 

I have about 35 charts on individual sheets that are all based on their own
PivotTable. I had to save the file to a new location, and when I go to
update the charts in the new location, it appears that each of the charts
maintained the link to the old file, even though the files have the same
name, just different file paths.
To compound the problem, when I right-click on the chart, and try to use
"Select Data...", the "Chart data range:" field is greyed out. How do I get
the charts focused on the new file? ...How do I get my charts to start
working off the new file location?

TIA,
b.