Update #REF! to Active Workbook

  • Thread starter Thread starter Apprentice
  • Start date Start date
A

Apprentice

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?
 
If you just want the chart for visual display in the master workbook, then
you could probably use the CopyPicture method to move them from the other
workbooks. They would not have the links that are associated with other
methods. Check it out in the VBA help file.
 
Back
Top