Array and cell limits

PI DataLink is subject to an Excel limitation on the number of elements in a calculation array. A single PI DataLink function can return no more than 1,048,576 values per retrieval.

The Excel SDK used by PI DataLink limits strings to 255 characters in length. Input strings for PI DataLink expressions in a referenced cell may not exceed this 255-character limit.

Similarly, PI DataLink might truncate string output, such as PI point names, to 255 characters.