ExcelBanter - Refresh workbook automatically

Automatically refresh data at intervals

Click a cell in the 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.), and then
click Data Range Properties on the External Data toolbar (toolbar: A
bar with buttons and options that you use to carry out commands. To
display a toolbar, click Customize on the Tools menu, and then click
the Toolbars tab.).

Select the Refresh every box, and then enter the number of minutes
between refreshes (refresh: To update data from an external data
source. Each time you refresh data, you see the most recent version of
the information in the database, including any changes that were made
to the data.).

--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=509144