The following options are available for a retrieval:

Growth Rates

• Do not display % sign
• Decimal precision

Aggregations

• Ignore NA (disregards values that are N/A)
• Round data before calculating growth rates

Other Options

• Excel Date - Start of Period
• Disable pop-up messages during retrieval (coloring of cells that contain error messages will not be disabled)
• Wrap text during retrieval
• Database list for range assignment

Menu and Retrieval Shortcut

• Menu Key (shortcut key to access the DLX Add-In menu)
• Retrieval Key (shortcut key to perform retrieval)

Update workbooks automatically when opening the file.

1. Go to DLX > Tools > Auto Update on Open
2. Copy the code
3. Open VBA Editor
4. Paste the code in the file 'This Workbook'
5. Save the VBA Editor

Make your spreadsheet static by archiving it. This will prevent your spreadsheet from being populated with new data from a retrieval.

1. Select the spreadsheet to be archived
2. Go to DLX > Tools > Archive SpreadSheet

An archived spreadsheet will contain the spreadsheet's name and the time it was archived.

Edit an existing range to include more cells in your retrieval. Empty cells can be included for future code entries.

1. Do one of the following:
   • Go to DLX > Tools > Edit Ranges
   • ctrl + f3
2. Select the range name then click on the at the bottom



3. Select the new range of cells then click on

The top-left most corner must start with the date-span

4. Click OK

Used for clearing retrieved data prior to changing the date span

1. Go to DLX > Tools then select one of the following:
   • Clear DLX Retrieval (Workbook)
   • Clear DLX Retrieval (Worksheet)

Data must be cleared prior to changing the date span otherwise there may be left over data from the previous retrieval with the old date span.

Used to rename DLX ranges to properly formatted ranges, unique range names in order to perform a successful data retrieval.

1. Go to DLX > Tools > Check Range Compatibility
2. Select Rename
3. Click OK

Move or copy the selected sheet to the current workbook or to another workbook.

Move Sheet

1. Select the sheet you wish to move
2. Go to DLX > Tools > Move or Copy Sheet...
3. Select the workbook
4. Select where you wish to place the sheet
5. Click OK

Copy Sheet

1. Select the sheet you wish to copy
2. Go to DLX > Tools > Move or Copy Sheet
3. Select the workbook
4. Select where you wish to place the sheet
5. Check Create a Copy
6. Click OK

It is important to use Move or Copy Sheet as this will maintain the range set up in your worksheet(s).
Simply using copy and paste will not.