Professional OPC
Development Tools

logos

lupa

Online Forums

Technical support is provided through Support Forums below. Anybody can view them; you need to Register/Login to our site (see links in upper right corner) in order to Post questions. You do not have to be a licensed user of our product.

Please read Rules for forum posts before reporting your issue or asking a question. OPC Labs team is actively monitoring the forums, and replies as soon as possible. Various technical information can also be found in our Knowledge Base. For your convenience, we have also assembled a Frequently Asked Questions page.

Do not use the Contact page for technical issues.

  1. Forum
  3. Discussions
  5. Excel Connector
  7. Excel RTD - Data Refreshing stops for 5 seconds

Excel RTD - Data Refreshing stops for 5 seconds

More
29 Oct 2019 09:44 #7887 by support
Replied by support on topic Excel RTD - Data Refreshing stops for 5 seconds
Hello,

I have some questions that would allow us to steer the investigation better:

1. Is your connection to the server using security (signing, or signing+encryption)?

2. Besides having cells that show the actual data values,k do you also have cells mapped to status, and error messages, associated with each node? If so, what do they show when this happens?

3. When it happens, are all items coming from the same server affected at the same time, or do some work OK while others are stalled?

4. If you are using more OPC servers on the same sheet, are they all affected at the same time?

Thank you

Please Log in or Create an account to join the conversation.

More
29 Oct 2019 07:48 #7886 by Enrico
Excel RTD - Data Refreshing stops for 5 seconds was created by Enrico
Hi,

we work with the excel option, which is really cool, because one can use all the powerful functions of Excel.

There is one thing which is a bit annoying. Every now and then the data refreshing in Excel stops for about 5 seconds.

The throttle rate in Excel for the RTD is already properly set, thus that we can receive and display data, with an acquisition rate of 5 Hz.

I wonder if you have an idea, in which direction I could take a closer look to identify the problem. I was thinking, some component tries to establish a network connection, and than after a time out, continuous with nominal operation. The RTD Server, Excel? Did you have a similar problem before?

Kind regards

Please Log in or Create an account to join the conversation.

Moderators: support
  1. Forum
  3. Discussions
  5. Excel Connector
  7. Excel RTD - Data Refreshing stops for 5 seconds
Time to create page: 0.047 seconds