I have been seething and searching in 'super' frustration at MS
recently. I need to copy worksheets (within a workbook) with numerous
equations and charts, all referenced within the sheet itself, and to
no other sheet.

When I use by bro's Office 2003 SP2 Excel, the copied sheet references
itself = perfect! Now I can modified the data within the cells of the
new worksheet, making new updated charts.  life's good.

When I use Office 2007 on my desktop, all of the graphs in the newly
copied worksheet, reference the original worksheet. Now the chart has
to be selected, and every item within that chart has to be updated to
reference the present worksheet. Too much work, and not going to
happen.

When I use my dell laptop with Office 2007, the cells are copied
perfectly, like my bro's office 2003. I cannot find a setting or any
info that defines the 'copy' parameters. And when I MACRO the 'copy'
on all three computers, the macro is exactly the same.

Why would MS make this blunder? Are they completely stupid, the way I
tend to feel about them most of the time, Or is it me and I am I
really missing something.

Any help would be 'super' greatly appreciated.