I have set up a dynamic chart using the Defined Name
=OFFSET(Template!$C$#,,,COUNTA(Template!$C$3:$C$20 000),1) Named datalabel,
and Defined Name =OFFSET(datalabel,0,1) Named data. These named ranges where
saved in chart1.xls and worked fine. However, When I re-created the same
Defined Names in chart 2.xlt and tried use them in a chart, a message
returned Referrence not valid, Work book must be open? chart2.xlt was open?

Is 'Template' the name of the worksheet or the workbook? If the former, it
should work -- I just verified it. If the latter, change your workbook so
that the defined names have a scope of the worksheet. To create such a
defined name, define the name as {worksheet name}!{actual name} rather than
just {actual name}.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"mark1035" wrote:

I have set up a dynamic chart using the Defined Name
=OFFSET(Template!$C$#,,,COUNTA(Template!$C$3:$C$20 000),1) Named datalabel,
and Defined Name =OFFSET(datalabel,0,1) Named data. These named ranges where
saved in chart1.xls and worked fine. However, When I re-created the same
Defined Names in chart 2.xlt and tried use them in a chart, a message
returned Referrence not valid, Work book must be open? chart2.xlt was open?