Reference Links

Reference Links return data from a single record. The link is represented by a formula retained in a target cell within the workbook. A single query can output multiple data items for that record. The values are not aggregated.

Reference Links are formula link definitions. The formulas are prefixed with QAA_RL. Formulas can be saved within the workbook and copied to other locations in the workbook.

Reference Links are typically used with other types of data extraction. The Debtors Inquiry shows the combined use of a Reference Link along with Summary Links and a Detail Report on the same worksheet.