I thought I posted this but don't see it on the list. I'll try again, may be
the operator, maybe the same problem I am having with Excel. : )

I have two worksheets, one is called Charts and the other called Data. I
need to make mulitple copies of these two charts for seperate data sets. I
want the charts links to follow to the new data worksheet like the cell
formulas do.

This is what I do:

<Cntrl Right click> to hightlight both worksheets
Right click on the tabs and select Move/Copy check the copy box
Create new copies that have the names Chart (2) and Data (2)
The Cells in Chart (2) reference Data (2), but the charts still reference
the original worksheet Data. I want the chart links to follow to Data (2).
Any suggestions?
I am working with Excel 2000.

Thanks,

David