Thanks in advance.

I have 60 workbooks with 7 identical worksheets. I have added some graphs
and charts to one of the workbooks (Master Workbook).

I want to use these charts with the remaining 59 workbooks. I am currently
using code to import each set of workbooks into the master. Then I save the
master as a new file.

The import works great but the references used in the charts are invalid
after import.

Is there a way to "update" the referances to the active workbook (Master) or
can I set the references in the charts to be absolute/constant/protected?

If so how could I do that?
--
Your guidance is greatly appreciated!