Micro to Exel DDE

[DGR 0]

I am using the N7 file to store data in a ML 1100 and am sending to Excel. This seems to work fine until I try to link from N7:100 or more. When I do this my Excel cells display a "#N/A". If I am in my RSLinx Data Table Monitor and try to navigate to N7:100 or more the entire file will display "Error!" (with a yellow background) in each integer file. Is there a data limit for hot links?

[TimWilborne 108]

Yes there is and i believe it is 100. Add a second dde topic starting at n7:100

[DGR 0]

I tried the first topic with N7:0,L24,C1 and the second topic with N7:120,L24,C1 but it didn't seem to like that either. I'll keep scratching. Thanks for your reply.

[TimWilborne 108]

Are you sure you created a second topic. Simply copying and pasting a link a second time wont work. You must create a second topic in rslinx. We had to do this on one of our Controllogix machines. We were sending 300 DINTs to it. To do this we had to stagger our arrays 96 words at a time. It works fine.