Rtd, update multiple cells with one request

Sep 8, 2014 at 9:11 PM
Is it possible to update multiple cells with one request in RtdServer? Currently, I can only update one cell with one request.
Sep 8, 2014 at 9:17 PM
You can use your wrapper as an array formula (with Ctrl+Shift+Enter) and in the RTD set an array.
There are some complications though, since Excel doesn't really support arrays in RTD.

It's usually better to arrange things so that many RTD formulas share some back-end data structure that you update from the live feed. That's much faster than trying to follow the array approach.