Hi,

I have a problem with making charts linking to external workbooks. Let's say I wan't to make a couple of charts in workbook "ChartBook.xls", that uses data from linked workbook "DataBook.xls".

I have for example made a named range called "AHeader" defined like "='D:\Data\[DataBook.xls]Sheet2'!$A$1".

If I use the named range in a field in ChartBook.xls like "=AHeader" it's fine and shows the correct text even if "DataBook.xls" is closed.

But if I make a chart in "ChartBook.xls" and insert "=Sheet1!AHeader" in a name-field for sourcedata, I get an error about that the reference cannot be found, but this only happens if "DataBook.xls" is closed, when "DataBook.xls" is open everything works fine.

Can somebody please help? Thanks!