Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formulas over merged cells | Excel Discussion (Misc queries) | |||
Copy/Paste formulas in merged cells | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Formulas in Merged cells | Excel Discussion (Misc queries) | |||
Formatting results of formulas within merged cells | Excel Discussion (Misc queries) |