PDA

View Full Version : Problem with DDE/OPC- rslinx, retaining numerical data



lbettac
2016-02-23, 07:00 PM
I'm having trouble retaining data from our plc when getting it through rslinx onto excel. I have an excel sheet that is recording a number from a counter on the plc. Every hour, on the hour for 24 hours, I request and collect the counter accumulated number into a different cell. I can receive and retain the data for some hours, but at random, an error occurs and the whole spreadsheet is wiped clean.
Does anyone have an idea of what is happening and how it can be fixed?
Attached is my excel sheet.