XL2000: Incorrect URL Pasted After Browsing to Web from New Web Query Dialog Box (210691)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q210691

SYMPTOMS

An unexpected Uniform Resource Locator (URL) may appear in the New Web Query dialog box after browsing to the Web.

CAUSE

When you click Browse Web in the New Web Query dialog box (point to Get External Data on the Data menu, and then click New Web Query), a new instance of the browser starts. If a Web browser is already running when you do this, then when you switch back to Microsoft Excel, the box in step 1 of the New Web Query dialog box contains the URL from the first instance of the browser.

WORKAROUND

To work around this behavior, use either of the following methods:
  • Close any instances of the browser before you click Browse Web.

    -or-

  • Copy the URL from the address box of the browser you are already using, switch to Excel, and paste it in the box in step 1 of the New Web Query dialog box.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbbug kbpending KB210691