I am a longtime user of Excel 2003 switching to 2007. Among the many annoying changes they have made (sure there are many good ones too!) is the following:
With Excel 2003 if you copied a sheet that had a graph embedded in it, everything would copy across nicely and the graph in the new sheet would refer to the rows and columns in the copied sheet, ready for you to put new data in it.
Now I find with Excel 2007, the graph in the copied sheet still has all its references pointing to the old sheet, so that you have to click on each of the graph curves and change the references, or create a completely new graph! This can be very annoying if there are a lot of curves or you have spent a lot of time formatting your graph.
There MUST be an easy way to solve this.
Can anyone help me with this?

Frank