- Setting up a New Web Query in Excel 2000 or earlier

Setting up a New Web Query in Excel 2000 or earlier

Setting up the Web Query is a little different in earlier versions of Excel. Below is the New

Web Query screen. Option 1 is where you enter the application and operation’s URL. After

setting the URL you need to set the second option to use only specific HTML tables. Use

the table identifier “WOW” which is the standard HTML table id that WOW will generate for

data tables. Then after setting the third option to none, the web query should be ready to

run.

You will get the import data screen asking where you want to put the table data from

WOW. Select a location and click OK.

After selecting where to put data, Excel should say “getting data” and display the WOW data

in an Excel table as shown below.

After the table has been created, you can right click anywhere on the data for various web query

options (refresh values from web, edit query information, or edit range options).