[Karyn Mak]

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

[Don Guillett[_4_]]

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.

[Karyn Mak]

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.


.