Thread: Web Query fail to Refresh All but individual refresh is ok
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
  
Posts: 2,337
Default Web Query fail to Refresh All but individual refresh is ok
try
Worksheets("yourworksheet").Range("b5").QueryTable .Refresh
BackgroundQuery:=False

or maybe
for each ws in worksheets
ws.querytable.refresh backgroundquery:=false
next

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Karyn Mak" wrote in message
...
On Excel 2002, the web query "Refresh All" function
fails. individual web query refresh is ok.


Reply With QuoteReply With Quote