Refresh a Web query

  1. Click a cell in the region of the worksheet where your query data was returned (also known as an external data range (external data range: A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.)).
  2. Click Refresh Data Button image on the External Data toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.).

A spinning refresh icon refresh indicator appears in the status bar (status bar: A horizontal bar at the bottom of the screen that displays information about the current condition of the program, such as the status of items in the window, the progress of the current task, or information about the selected item.) to indicate that the query is running. Double-click the icon to check the status of the query.

ShowTips

  • You can have your data refresh automatically when the file is opened, at timed intervals, or in the background by clicking Data Range Properties Button image on the External Data toolbar and selecting or clearing options under Refresh control.
  • If the data returned to your worksheet after a refresh isn't what you expected, check the Web page you are querying to make sure it is in the same location and that the data on it is provided in the same way as when you created the query.
 
 
Applies to:
Excel 2003