View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HUGO HUGO is offline
external usenet poster
 
Posts: 30
Default how do i autorefresh a datasource every 5 seconds in Excel?

I have a worksheet in Excel that retrieves data from a sql server 2000
database. How do i get this datasource to refresh every 5 seconds?

Right now i have a refresh in minutes but i need seconds unit....