iYogi

Computer Problems? Call Toll Free @ 1 877 316 9417
Troubleshoot all your computer problems with certified tech experts, Call Today!
http://support.iyogi.com

Question

How to fix the issue when clicking on hyperlink in a web query opens a new browser window

Reason
Some web pages contain hyperlink that are designed to open the linked web page in a new browser window. This is why when you click a hyperlink in a web query, it sometimes opens a new browser window on the screen.

The solution to the problem

Follow the instructions to fix the issue when clicking a hyperlink in a web query opens a new browser window:

  1. 1

    Copy the Web address from the new browser window.

  2. 2

    Click a cell in the region of the worksheet where the query data was returned (also known as an external data range).

  3. 3

    NOTE: If you know the name of the query but are not sure which region of the worksheet contains the query data, click the ‘Name’ box, and then click the name of the query in the list.

  4. 4

    Click ‘Edit Query’ on the External Data toolbar.

  5. 5

    Paste the Web address to the ‘Address’ box in the ‘Web Query’ dialog box.

  6. 6

    Click on ‘Go’ to open the Web page in the ‘Web Query’ dialog box.

Footnotes:

You can also resolve this problem if you copy and paste the web address from the new browser window to the address box in the web query dialog box. Then click on ‘Go’ to open the web page within the web query dialog box.

Leave a Reply

*