Change a Web query

Select or type a new URL in the Address box.

Click to cancel the selection of a selected table or click to select a table.

If there are no next to tables on the page, click Show Icons at the top of the dialog box to display them.

1. Click Options.

2. Do one of the following:

   Under Formatting, click one of the following:

   • None    Returns none of the formatting on the Web page you are querying, only text. Formatting that exists on the worksheet is applied.

   • Rich text formatting only    Returns the type of formatting that Microsoft Excel can reproduce most closely, such as font styles. Does not include HTML formatting, such as hyperlink formatting.

   • Full HTML formatting    Returns all HTML formatting that Excel supports, such as hyperlink formatting. This option clears the Preserve cell formatting check box in the External Data Range Properties dialog box.

   Under Import settings for preformatted <PRE> blocks, select one or more of the following:

   • Import <PRE> blocks into columns    Blocks of data surrounded by <PRE> tags will be imported into separate columns on the worksheet. Clear this box to return data into a single column.

   • Treat consecutive delimiters as one    If you have characters that define, or delimit, the text for each column in your <PRE> sections (such as commas), you can specify that when Excel encounters more than one of these delimiters together, they will be treated as one so that a blank column is not placed between each consecutive delimiter. This check box is available only when you select the Import <PRE> blocks into columns check box.

   • Use the same import settings for the entire section    Select to use your setting for Treat consecutive delimiters as one for all preformatted sections on the Web page. Clear this check box to use your setting for the first preformatted section only or if you want Excel to determine the best settings. This check box is available only when you select the Import <PRE> blocks into columns check box.

   Under Other Import settings, select one or more of the following:

   • Disable date recognition    Ensures that numbers on a Web page that appear similar to dates appear as numbers on the worksheet. For example, a sports standing score of 03-07 is recognized by Excel as the date March 7 unless this option is selected.

   • Disable Web query redirections    Ensures that the Web query is not redirected to a different data source than what you see on the Web page you're querying. Select this check box for compatibility with queries created in previous versions of Excel.