Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy formulas over merged cells Narendra Boga[_2_] Excel Discussion (Misc queries) 2 July 4th 09 07:22 AM
Copy/Paste formulas in merged cells Excel User 123456 Excel Discussion (Misc queries) 2 December 18th 08 07:58 PM
Autofit Merged cell Code is changing the format of my merged cells JB Excel Discussion (Misc queries) 0 August 20th 07 02:12 PM
Formulas in Merged cells TooBaaaadd Excel Discussion (Misc queries) 2 February 8th 07 01:55 PM
Formatting results of formulas within merged cells jondlieber Excel Discussion (Misc queries) 2 October 28th 06 02:48 AM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"