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.

Comments (0) New comment

Engr. Rizwan Hassan Rank: 496

Asked 1 year ago

Answer this question Follow

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.

Comments (0) New comment

Engr. Rizwan Hassan Rank: 496

Answered 1 year ago

Other questions needing answers

AKS experts

Stefan Stromqvist AKS expert

Rank: 1

Ask

Flavio Mussolin AKS expert

Rank: 4

Ask

Titus

Rank: 6

Ask

kstoilov

Rank: 5

Ask

Geof Ledin AKS expert

Rank: 40

Ask

Ingo

Rank: 36

Ask

Dieter Henkel AKS expert

Rank: 12

Ask

backdraft

Rank: 24

Ask

Question details

Error 1004 Displaying history data

Answers

Other questions needing answers

Related topics

AKS experts