Auto refresh

  • Thread starter Thread starter Igor G.
  • Start date Start date
I

Igor G.

How to automaticaly refresh all sheets in workbook every 5 min?
Thanks
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Auto update some spreadsheets inside a shared workbook and NOT others 0
Refreshing external data on individual sheets in a specific sequen 1
Refresh data with macro code 0
Pivot Table Refreshing 2
this action will cancel a pending refresh data command 3
Wait till pivot finishes refreshing 1
VB refresh of query 2

Back
Top