View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alfredo_CPA Alfredo_CPA is offline
external usenet poster
 
Posts: 45
Default Automatic Update links to web query

1. Are there any way to Automatic Update links to web query.
Let say, I want to simulate clicking the refresh button every 60 seconds.

2. My web query is in sheet2 (showed as raw data). My usefull (already
manipulated data) with links to sheet 2 is in sheet1. I noticed the refresh
option is available just when I'm in sheet2. Are there any way to refresh the
web query from sheet1




--
I'm not a looser, I keep trying€¦