Change chart/graph series reference from one workbook to another

[alektherussian]

Hi guys,

I have two similar excel workbooks, one [Model.xls] serves as a model for another [Target.xls], so that the cell references for the ranges are the same in both spreadsheets.

Model.xls contains charts/graphs that I want to move to Target.xls. I want these objects to reference the same data ranges but in Target.xls instead of model.xls.

E.g., in Target.xls change SERIES('[Model.xls]Sheet1!$A$1:$B$5,'[Model.xls]Sheet1'!$A$1:$B$5,1) to SERIES('Sheet1!$A$1:$B$5,'Sheet1'!$A$1:$B$5,1).

I would really appreciate your help!