Web Query fail to Refresh All but individual refresh is ok

  • Thread starter Thread starter Karyn Mak
  • Start date Start date
K

Karyn Mak

On Excel 2002, the web query "Refresh All" function
fails. individual web query 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
 
It is based on OLAP source data and according to MS Excel
Help, background query is not applicable. Any other ideas?
 
Back
Top