Dynamic Arrays

Dynamic Arrays, added around 2019 to Excel, are optimized arrays, useful for posting realtime data.

The AddOn posts data to Excel as Dyamic arrays.

Excel has some built-in functions that are dynamic array aware and make it easy to work with them when creating your customized dashboards and views.

Searching for information on dynamic arrays will result with many tutorials and video examples.