AnsweredAssumed Answered

Question about substituted values

Question asked by a.olsen on Aug 17, 2018
Latest reply on Aug 17, 2018 by a.olsen

We use older Excel sheets with PiPutVal macros to record some laboratory data still. Since the workbooks inception (20 years ago) there have been some issues.

There are buttons that enable the user to input a time and a date. Then clear and submit the entered data.

For some reason unknown to me, every Thursday at the 6 AM timestamp, the value is substituted for some random number. It only happens for the RVP cell, and only on Thursdays at 6 AM. No matter what they enter, the data sent to PI when clicking record changes.

You can see the spikes every Thursday at 6 AM.

Any ideas? The macros are all the same. The formatting is the same for the cells.

I can attach the sheet, but I'm not sure how macro enabled workbooks are handled.

Outcomes