you can use the ONTIME method - read HELP

That works when the workbook is open all the time

If you want it to open , refresh then close, you can set the windows Task
Manager to run the spreadsheet, then have the workbooks Open event refresh
the sheet, then save itself and close


"Igor G." wrote:

How to automaticaly refresh all sheets in workbook every 5 min?
Thanks