Setting Query Properties

You can modify query properties in Excel by right-clicking any cell in an existing query range and selecting Data Range Properties. This option opens the External Data Range Properties dialog box, as shown in the following image.

External Data Range Properties dialog box

Some of the External Data Range Properties options that you can control include:


WebFOCUS