Web Query fail to Refresh All but individual refresh is ok
 

On Excel 2002, the web query "Refresh All" function
fails. individual web query refresh is ok.

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.

Web Query fail to Refresh All but individual refresh is ok
 

It is based on OLAP source data and according to MS Excel
Help, background query is not applicable. Any other ideas?

-----Original Message-----
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.


.