Changing Chart Title reference while replicating Sheets

I created some charts in a sheet (Sheet1) and would like to replicate it in another sheet (Sheet2). The charts titles are using a cell to pick up the value. I use the = (equal sign) pointing to the cell with the title. When I duplicate the Sheet1 (with Move or Copy) the chart titles sheet reference is not changed. For example I have the Sheet1 with charts pointing to cell D2, this is what is in the chart title: =Sheet1!$D$2. When I replicate the Sheet1, the charts title on Sheet2 are not updated with =Sheet2!$D$2, instead, it still remains with Sheet1 reference: =Sheet1!$D$2. Is there a way to change all the charts title at once? I tried to go to Find & Select, and clicking on Replace but did not work.

Can anyone help me, please?

Thanks!

It does not allow to remove the ($). When I try to remove the ($) it reverts back with signs ($).

I also tried in excel 2003 and it worked... however, I need it in excel 2007....

can anyone confirm if this is really impossible? or only via VBA Macro?

Hum.. My service pack level looks to be old.
Microsoft Office Excel 2007 (12.0.4518.1014) MSO (12.0.4518.1014).

How can I get the newest service pack from Excel 2007?

Inside Excel I clicked for Check updates to get the latest updates available for Microsoft Office and it did not find the most current service pack for excel 2007. I was also unable to find it in Microsoft web site.

My colleague found it to me. I have just installed and the replication of sheets worked with the chart`s title. Thanks a lot!