I have one workbook that contains only data. A second workbook contains only
plots linked to the worksheet with data. These two files corresponds to a
single case. Other cases will each contain a comparable set of workbooks. I
am able to copy the workbook with plots to the new case folder and change the
links (ChangeLink). However, I am unable to get the new data saved in the
new plots workbook.

I have tried opening the new data workbook first, opening the new plot
workbook, changing the link and saving the plot workbook. The link is
updated. However, no new data unless open the data workbook first or select
Update data from the messagebox. Running UpdateLink when the data workbook
is oipen causes an error.

I have tried opening the plot workbook without updating any
references(Workbooks.Open(sFilename, 0)), changing the link and saving the
plot workbook. The link is updated. However, no new data unless I do as
above. Running UPdateLink does not cause an error. However, the data values
are not replaced.

I have tried SaveAs after both of the above attempts. Same results.

What am I doing wrong.
What am I not understanding?

John