Hi,

You might try copying as follows.

1. Select the whole sheet by clicking the top left corner
2. Press Ctrl+C
3. Move to a blank sheet and select cell A1
4. Press Ctrl+V

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"DaveH" wrote:

I have a number of graphs imbedded in a worksheet, all using data from that
worksheet and only from the worksheet.

I would like to run a different analysis on the data and keep the original
analysis so I am trying to create a copy the worksheet and embedded charts in
the same workbood.

When I select "move or copy" selected sheets, with the "create a copy" box
checked, the worksheet is copied to a new tab, but the graphs are dropped.

There are a large number of graphs so I would like to not have to redefine
the ranges to point to the new data on each chart as would happen if I copied
the graphs from the old worksheet to the new, chartless worksheet.

This used to work as you world expect in 2003, but I can repeat this
behavior on any new or old workbook in 2007.

Is there a fix for this or a workaround for this bug?

DaveH