Modifying Data in XLSX Worksheets

If you have downloaded a Report Builder report in Microsoft Excel Workbook (.xlsx) format, you can augment the data shown using a pre-built function to display the data displayed for a named data range.

For example, your downloaded report might contain the following named data ranges:

Example Table.

Table 1
Company Name	USA	USA
Merlin Technologies Ltd	2049	464
Merlin Technologies Pty.	167	832
Merlin Technologies, Inc.	3525	894

To display the data for a named data range elsewhere in your report, perform the following steps:

1. Click into the cell you want to use to display data from your source named data range.
2. Enter = and type your named range. For example, Table1.
3. Double-click your selected range.
4. Press Enter. The named data range is now copied to its new location in the worksheet.

Notes:

You can display data from named data ranges in multiple sheets if required.

If you have identically named ranges, these are appended with a number to differentiate between them during selection. For example, if you had two data ranges named USA and USA, these would be displayed for selection as Table1_USA and Table1_USA2.