Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
Excel dde links
Posted by Mark Edwards on April 30, 2001 12:50 PM
Hi,
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?
Re: Excel dde links
Posted by Gary on May 06, 2001 6:53 PM
Mark:
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.
Gary
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.