Skip to main content
InSource KnowledgeCenter

034087 - Unable to retreive values in AF Workbook, comes back with #VALUE!

Problem

The customer is trying to run a query for historical values in an AF Excel Workbook. When he tries this the data comes back without any values, just #VALUE!.

Product Version: 9.2

OS: Win 2003

OS_SP: SP2

Solution

We tested the data by running ActiveFactory Query and we were able to see all the data successfully and with good quality. The customer is also has other tags looked at in the excel workbook, but just these new ones do not work. We created a new workbook and it then worked correctly. It appears that there may be some corruption in the original workbook which was causing it to fail during the query.

Close Date: 2010-06-07 10:54:49