Skip to main content
InSource KnowledgeCenter

047299 - Historian Client - Excel - Only getting one data point

Problem

When viewing a HC Excel Workbook, the Tag Analysis and Historical values queries do not return data. But Query does show the data. The same query gets used in both however.

Product Version: 10.0

ProdSp: SP2

OS: Win 7 64 bit

Solution

Found that the Historian Client addin for Excel had been incorrectly pointed to an .xla/.xlam in the individual user's profile, as opposed to the ones in the common files folder. To fix this the addins were redirected to the files in c:\program files\common\Archestra with the ActiveFactory adding pointing to HistClient.xla and the Historian Client addin going to HistClient.xlam.

Close Date: 2013-03-14 16:37:13