View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default Arrays & Defined Names

Hi,

Firstly: Check your workbook and sheet reference path(s).

Secondly: Check whether your name reference still referes to old named
reference name. Changing the named reference will not change the references
automatically. You will have to delete recreate the named references again in
your formula. Named reference does not support Dynamic Data Exchange.

Challa Prabhu

"Bec" wrote:

I have two linked workbooks of which contain arrays and defined names. It
appears that when I have defined names they haven't gone across to the
linking workbook. Is this right or what have I missed.