Error 1004 Displaying history data
Dear All,
While creating reports using excel and ABB data direct, I receive following error message from Data Direct.
"Error 1004 displaying history data Unable to set the FormulaArray of the Range class".
I am able to get values from other tags only a few tags return this error. Any help please.
BR.
Answers
Problem solved by reducing character length of my array. Excel supports 255 characters array. Either we have to reduce length or split up formula into chunks.
Add new comment