View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Array formulas are not valid in merged cells.

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.

--
Regards,
Tom Ogilvy



" wrote in
message ...
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