phuz
Member
I have a customer who is using Excel to manage recipe files. I have macros that look for data changes to enable loading, saving, etc. One of the tabs has real-time data from the current recipe and today I get a phone call about the dreaded #N/A in all the cells. This happened once before where I had to re-create the DDE topic before it started talking again. It's been several weeks since there has been an issue and I am wondering what is causing it. I actually have two DDE topics configured to point at the same ethernet SLC 5/05. The other excel file is running to create datalogs which export to a csv file. Is there a problem having two topics pointing to the node? Can both files use the same topic without problem?
Under the data collection tab in the topic configuration in RSLINX, I have polled messages enabled and set for 1000ms. Limit maximum packets enabled and set to 20. Update hotlink after poke is enabled. Optimize poke packets is enabled. That's it. Most of the time it works great. I've had them reboot and it still won't communicate.
I've sent a request that they remove the topics and re-add them which I am pretty sure will resolve the issue for now. But I need something a little more permanent. I don't like this issue of recipe management, but they chose it and now that it's not talking, they are down.
Under the data collection tab in the topic configuration in RSLINX, I have polled messages enabled and set for 1000ms. Limit maximum packets enabled and set to 20. Update hotlink after poke is enabled. Optimize poke packets is enabled. That's it. Most of the time it works great. I've had them reboot and it still won't communicate.
I've sent a request that they remove the topics and re-add them which I am pretty sure will resolve the issue for now. But I need something a little more permanent. I don't like this issue of recipe management, but they chose it and now that it's not talking, they are down.