Update external data on a timed basis in Excel 2000
If you maintain data in a worksheet that's retrieved from an externalsource, such as a database or the Web, you may need to periodically refresh the data to ensure you're working with the most current information. Fortunately, Excel 2000 now lets you refresh data at timed intervals, making it easy to keep data updated. First, select a cell in the area of the worksheet displaying the external data and choose Data | Get External Data | Data Range Properties from the menu bar. Then, select the Refresh Every check box to enable the associated Minutes spin box. The default setting is 60 minutes, but you can change it to any number of minutes between 1 and 32,767. When you've finished, click OK.
Created Date: 12/11/2001 Last Reviewed: 12/11/2001 Rev. Date: