Dear all,

I have a sheet with some dynamics charts, and when use "move or copy"
to copy the sheet, all the chart formula changed to fix series
numbers.

Is there anyway to copy sheet in which dynamic charts keep it dynamic
formula?

In case you didnt know, I use "local define name" in the chart fomula.

Thanks all.

This happens to local names when used as source data in a chart. It's an
inconvenient feature.

Move the sheet to a new book, save this workbook, and close the original
workbook without saving. Now open the new book whenever you need the chart,
and copy the sheet to wherever you need it. You could turn the new workbook
into a template, and insert a new sheet based on this template.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Yurble" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Dear all,
>
> I have a sheet with some dynamics charts, and when use "move or copy"
> to copy the sheet, all the chart formula changed to fix series
> numbers.
>
> Is there anyway to copy sheet in which dynamic charts keep it dynamic
> formula?
>
> In case you didnt know, I use "local define name" in the chart fomula.
>
> Thanks all.
>

It works Jon, Thank you very much. You are so kind

Btw, I have faced with another trouble. It copy all global named name
and transfer it in to local name... SO, I have 2 similar name at the
same time in which one refer to the template file (you mentioned)

Sorry, I'm wrong. It completely works