Web Query fail to Refresh All but individual refresh is ok

K

Karyn Mak

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

Don Guillett

try
Worksheets("yourworksheet").Range("b5").QueryTable.Refresh
BackgroundQuery:=False

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

Karyn Mak

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Refreshing 0
Pivot Table Refreshing 2
Wait till pivot finishes refreshing 1
Determining if a query is refreshing 1
MS Query 7
Refresh a local web page via Excel 3
Refreshing NON-embedded External Data Connections 1
excel external data range "failed to refresh" 0

Top