After you create a web query for a particular web page, it is quite possible that the data on the webpage will change over time. Stock quote information can change frequently, as can other types of financial data available on the web. To update your worksheet with the latest data, you will have to refresh the web query.
To do this, right click on the data range imported by the query, and select ! Refresh data from the menu that appears. You can also select a cell in the imported range, and choose data->! Refresh Data from the menu bar.
If you right click on the imported data range, and select Data Range Properties from the menu that appears, you will be presented with options for refreshing the imported data, and for modifying the data range.
You can see the name of the data range in the Name field. You can edit this name as you wish, and use it as a defined name for the range in place of standard cell references.
Under the Refresh control heading, you can place a checkmark in the box labelled Refresh every, and select the time duration of your choice. For instance, if you select 10, the data range will be refreshed every 10 minutes.
You can also choose to have the data refreshed every time the file is opened.
You can also adjust the formatting and layout options of the data range, and specify what should happen if the range changes when it is refreshed (i.e. gets larger or shrinks).
There is also an External Data toolbar that you can use to work with web queries.
· The first button on the left of the toolbar is the Edit Query button, which will display the Edit Web Query window · The button immediately to the right of the Edit Query button is the Data Range Properties button. This button will display the External Data Range properties box as shown above. · The red exclamation mark (!) will refresh the imported data.
If you want to use the External Data toolbar, choose View->Toolbars from the menu bar and select External Data from the list of options. |
