I'm looking for a technique to make charts automatically reference data on
the current worksheet when I copy a worksheet containing a chart. In Excel
2007, the chart references the cells from the original worksheet while Excel
2003 would automatically update the reference. I can manually key in the new
worksheet as the reference but this is tedious.

any suggestions?