DataDirect - Error Code 1004 Displaying History Data
Hello, Everybody
Do anyone know what error code 1004 displaying history data means when using DataDirect / History Values?
I am trying to schedule a monthly report using history values from the 800xA History Server. When creating the report using Data Direct, the following message is displayed:
"Error 1004 displaying history data. Uneble to set the FormulaArray property of the Range class"
We have reviewed all the settings for report configuration (users, add-ins, formula, etc) as per 800xA manuals but the messages still been displayed. We have also rebooted the servers with not joy.
Running system is:
800xA Sv 5.1 FP4 (Redundant ASCS)
800xA History 2.0 ru2
MS Excel 2013
Many Thanks.
Answers
it looks like an excel error ( not data direct )
http://stackoverflow.com/questions/30...
.FormulaArray
will only accept a 255 character or fewer string.
Add new comment