Excel on another computer cannot connect to DDE Server

Oct 16, 2009 at 7:07 AM

Dear all,

If Excel and DDe Server are in the same computer, excel can show with the formula =myapp|Form1!Number1.

But if Excel on another computer, I have run DDEShare on DDE Server and assign sharename and assign trust.

Type formula ='\\machinename\NDDE$'|'myapp$'!Number1.

It show "#N/A".

 

WHY???