MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel dde links

Posted by Mark Edwards on April 30, 2001 12:50 PM

I am trying to link to Excel Sheets together across a network without much joy.

The reading i have done so far suggests running 'clipbook' and 'netdde' on both machines copying the data into clipbook on the machine selecting 'share' then connecting to this clipbook from the remote machine copting the data out then pating into excel!

This works fine except the cell comes back with #N/A and the formulae appears to be set up as an array formulae (i.e. with { } around it).

Can anyone help? what am i doing wrong?

Posted by Gary on May 06, 2001 6:53 PM

I ran across your first link from 4/11/01 a little while ago and posted a reply.
According to the second link clipbook no longer works at least with NT or 2000 as the server.
Also look at the note at the bottom of the first link as it addresses the #N/A problem.
Try looking there and then let me know if I can be of any further help.