Array formulas are not valid in merged cells.

[khinester6666]

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

 

[Tom Ogilvy]

paste your information in another cell that works.

select that cell and go to the formula bar.

highlight the information in the formula bar, and hit Ctrl+C to copy it.

go to the merged cell and select it.

go to the formula bar (click in it). do Ctrl+V to paste the information.

then hit enter.

You can now clear the formula from the original cell where you do not want
the information.