On Apr 15, 3:32 pm, Alice wrote:
This is very frustrating! I spent a week preparing a worksheet with a lot of
graphs on the same single sheet. I need to do the same for 20 different
departments. In previous versions of Excel (e.g. 2003) I just could copy the
prepared worksheet via 'Move of Copy' (rightclick on the tab) and all would
be fine. In Excel 2007 however, all graphs still link to data ranges on the
original sheet.

Example:
Sheet called "Total" with a graph with data series ='Total'!$E$15:$E$36.
Copy sheet to a new tab called "Dep1". In Excel 2003 the data series would
automatically be changed to ='Dep1'!$E$15:$E$36. In 2007 however, it is still
='Total'!$E$15:$E$36.

Please please please, is there any solution besides manually changing
hunderds of data series? Starting again in Excel 2003 is no option either.

Alice

I can confirm that this is indeed a bug or flaw in Excel 2007. As
Alice stated, Excel 2003 would correctly update the links when copying
to point to the data on the copied sheet. Excel 2007 instead
continues to point to the old sheet for the chart data. Maybe this
has something to do with the type of chart or the fact that the
workbook was created in 2003 and subsequently saved to 2007?