All cells in a block requested contain the same data

Problem

When entering the required formula in Microsoft Excel (for example,

DDESHARENAME'T4:0.acc,L5,C1'

) to establish a hot link to read a block of data from a processor, the link is established, but the cells in the block requested contain the same data.

Solution

This formula is used to request five timer accumulators starting from

T4:0.ACC

. Microsoft Excel uses an array formula to represent the data, thus cells contain the value of the data for the first address (

T4:0.ACC

). To correctly display the data re-edit the range of cells and then use

Ctrl+Shift+Enter

to enter the data. This enters the data as an array formula. For more information on array formulas, please refer to the Microsoft Excel User's Guide.