Emerson Exchange 365

Unloading OPC Client without closing Excel when using the Excel Add-in

I am trying to configure an report in Excel using the DeltaV Runtime Data Excel Add-in.  Every DVRead Function that I create in the spreadsheet counts as 1 OPC tag against our OPC license.  Since I would like to read a parameter from just about every tag in our system, and I only have about 400 OPC tags to use, I would like to loop through them using some vba in Excel.  The problem is, once you create a DVRead tag, it decreases your available OPC tags and keeps them until you completely close out Excel.  It does this even if you create a DVRead in Excel and then delete it.  

Is there any way to get around this limitation?  

• OPC Server
• DVRead
• Excel Add-in

John Giegel

• 9 Feb 2017 6:05 PM
• Cancel

5 Replies

• JoshC

  

  • 12 Jul 2018 12:53 PM

  Did you ever figure anything out?

  • Cancel
• John Giegel

  

  • 13 Sep 2018 1:31 PM

  In reply to JoshC:

  Well yes and no. As stated above, the OPC tags are not "released" for use until you completely close out Excel. So we wrote VBA in excel to capture 400 tags, copy the data to different cells, close excel, reopen, repeat until all tags have been read. It took some code development, but it actually works pretty reliably.

  • Cancel
• JoshC

  

  • 13 Sep 2018 2:29 PM

  In reply to John Giegel:

  Interesting. Are you using two instances of Excel.exe with one instance closing and reopening the other one?

  • Cancel
• BillS

  

  • 13 Sep 2018 7:52 PM

  In reply to JoshC:

  I represent SyTech, an Emerson partner. Our product XLReporter is equipped to read OPC tag values into a spreadsheet periodically or on events.
  We mange workbook and worksheet naming and can distribute automatically. What's better is that there is no programming and the deployment is free of Excel even though we produce Workbooks, PDF or Web Reports. Check out our web site www.sytech.com and watch a video on the subject.

  • Cancel
• dikshitsh

  

  • 25 Sep 2018 8:27 AM

  In reply to John Giegel:

  Hi John, Saw your thread on Excel Add in, My query is somewat similar, If you can please help.
  
  I am trying to read online parameters on excel through DeltaV excel add - Read real-time data , excel is installed on the Proplus.
  
  The OPC server is a different machine.
  
  I can configure and read the event chronicle and the historian parameters through excel add In, as while configuring those parameters,
  
  it gives me an option to change servers and I can link to my application station to read the data on excel
  
  but Whenever I try and read any parameter through DeltaV excel add in- Read real-time data,
  
  it gives me an error "Unable to add parameter path to server subscription.Exceeded OPC server license limit. Item not added."
  
  My OPC server has all the relevant licenses and I should not be getting this error while trying to read the online values of parameters in excel.
  
  Do I need to change any server settings in excel to point to my OPC server.
  
  If that is the case, How do I do that or any other thing that I need to do so that the data starts to appear in excel
  
  Any workaround on this an how can I change the Server when reading parameters through Read real-time data option.
  
  ANy help will be highly appreciated
  
  Thanks

  • Cancel