Array formulas are not valid in merged cells.

  • Thread starter Thread starter khinester6666
  • Start date Start date
K

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
 
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.
 
Back
Top