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.
Does anyone have an idea of what is happening and how it can be fixed?
Attached is my excel sheet.