Live copy to Excel from the Web client

This section describes how to copy a report from the AARO Web client to Excel, keeping all drill down functionality active.
To perform 'live copy' to Excel from the AARO Web client:

In the AARO Web client load or create the report.
On the Export menu, click Excel Live.

Excel Live menu on the Web client menu panel

Alternatively, in the report tree, expand the report menu and click Export > Excel Live.

Excel Live menu from the Web client report tree

The AARO Office add-in login window will appear if the user is not already logged in.
Select the same database and user name as was used in the Web client and click Login.
The Select Report Place dialog box appears.
In the Select Report Place dialog box, select where the report is to be inserted:

Active Sheet – currently opened sheet, next to other reports if applicable.
New Worksheet – new worksheet will be created.
New Workbook – new workbook will be created.

Excel Live menu from the Web client report tree

The report is pasted onto the Excel sheet according to the selected option.

Report exported into Excel from AARO web client menu panel

The loaded report is exported from the Export menu with the current parameters and report settings (for example, the Remove empty rows setting, as applicable). From the Reports tree the report is exported with saved parameters and report settings.

When using Excel live, only the table report component is pasted.