refresh data on exit

[dantb]

Hi all, what I have is a main worksheet (Unit1.xls), that is connected to several other xls files that I am using as dbase's. When the main worksheet is opened, it retrieves data , (query’s) from these files, such as (cs1). What I was wondering is if when I update one of the external files,(with Unit1.xls open), is there anyway that if the user saves there changes to the connected file (cs1.xls), It will automatically refresh the data in the main workbook without having to use the (refresh all) command in the main workbook. Thx Dan