The dynamic names I used to utilize in Excel 2003 to define the data range
for charts in my worksheets don't work anymore, because excel modifies them
upon saving the file :

Filename.xls!DynamicNamedRange gets changed to [0]!DynamicNamedRange for all
the chart series using this syntax.

Is there another syntax I can use ? Any workaround ?

If the data is in a Table (new XL2007 feature); the chart is automatically
dynamic
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jcollot" wrote in message
...
The dynamic names I used to utilize in Excel 2003 to define the data range
for charts in my worksheets don't work anymore, because excel modifies
them
upon saving the file :

Filename.xls!DynamicNamedRange gets changed to [0]!DynamicNamedRange for
all
the chart series using this syntax.

Is there another syntax I can use ? Any workaround ?

Supposedly SP1 takes care of this bug.

"Bernard Liengme" wrote:

If the data is in a Table (new XL2007 feature); the chart is automatically
dynamic
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jcollot" wrote in message
...
The dynamic names I used to utilize in Excel 2003 to define the data range
for charts in my worksheets don't work anymore, because excel modifies
them
upon saving the file :

Filename.xls!DynamicNamedRange gets changed to [0]!DynamicNamedRange for
all
the chart series using this syntax.

Is there another syntax I can use ? Any workaround ?