Repeat Last CDXZipStream Query
Previous  Top  Next


The "Repeat Last Query" function is available from the command bar and from the right-click menu. It automatically repeats the last settings and inserts new data in the active worksheet. There is no need to run the CDXZipStreamTM interface again. This also allows you to modify the list of indices to add or delete items and get the latest data, or to get data for a new list of ZIP Codes, as shown below. Select the first cell of the new list, then click on the "Repeat Last Query" button:


repeat1


And the result is:

repeat2

The "Repeat Last Query" function is also accessible within the Excel worksheet by right-clicking on the first cell of the ZIP Code list. See the Help section on this topic here.

The "Repeat Last Query" function is only available after a successful data retrieval, and is not available when an Excel session first begins.