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?
In reply to JoshC:
In reply to John Giegel: