4. Click the Import button. Excel will ask where you want the data imported. Choose a location for the results.
5. Click OK. The dialog box will disappear. For a few seconds, you will see a strange value in cell A1, followed by “Getting Data." In 1–10 seconds, the spreadsheet will redraw with a current version of the data from the Web page.
6. To refresh the data at any time, return to this worksheet and then click the Refresh All icon on the Data tab of the ribbon.
Figure 992 Choose the table to import.
Select a cell in the returned data and click the Properties icon on the Data tab. You can Refresh Data When Opening the File and/or to refresh the web query every N minutes.
Figure 993 Refresh data automatically every N minutes.