View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] khinester6666@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Array formulas are not valid in merged cells.

Hello,
I am trying to connect our ACT! to some excel templates,
byt get the above error everytime I try to paste link the
field.

I am trying to link these fileds using the Dynamic Data
Exchange (DDE) from ACT to Excel and I am following the
example in http://www.actnews.com/Articles/1997/97-
02/ConnnectACTtoExcelwithDDELinks.htm

and it works great, in any other cell, but not in the
actual cells that I want them to be linked to.

Can anyone shed some light on what this error is?

Thanks