Dear all,

I use external links to another excel file. In a formula with such a link,  
external links only work for numeric values, but not for text. If a cell  
with a text is linked, the value #N/A is displayed unless the linked file  
is open.

For instance, it happens when linking to cells of the file
http://www.eex.de/info_center/downloads/dl_futures/energy_derivatives_historie_2
005.xls

The formula
='http://www.eex.de/info_center/downloads/dl_futures/[energy_derivatives_historie_
2005.xls]F1BM'!D3
is properly evaluated. Probably, because there is a number in the cell.

But, the formula
='http://www.eex.de/info_center/downloads/dl_futures/[energy_derivatives_historie_
2005.xls]F1BM'!B3
is only properly evaluated, if the externally linked file is open. If the  
linked file is not open, #N/A is displayed.

The problem occurs with Excel 97 and Excel 2000. The text content in the  
cells is shorter than 255 characters (usually 5-15 characters). Thus, I  
don't think that the 255-characters DDE limitation is the cause for the  
problem.

Any ideas are appreciated. Thanks in advance.

Best regards,
Sven
--
Sven Filter, mailto:de893yd.z.sfilter@xoxy.net