/
Excel retrieve formulas

Excel retrieve formulas

Owned by Julia Ratniece
2022-03-14

Formulas in Microsoft Excel can be used to retrieve data from the AARO application into Excel workbooks. This provides extra flexibility and options for data manipulation in Excel.

This section of the manual refers to the Excel formulas used to retrieve data from AARO to Excel.

A set of predefined Excel retrieve formulas is provided with the AARO installation. More formulas can be provided by using the Formula Builder, for more information, see the Formula builder section. Revised formulas can be provided by an AARO consultant in certain instances.

The current limits for Excel retrieve are:

  • 30 dimensions;

  • 250 groups;

  • 3 string values;

  • 30 external dimensions.

Excel retrieve formulas can be combined with Excel send formulas and Excel reports. For further reference to those formulas, please refer to the appropriate section of the user manual.