K Karyn Mak Jul 16, 2003 #1 On Excel 2002, the web query "Refresh All" function fails. individual web query refresh is ok.
D Don Guillett Jul 17, 2003 #2 try Worksheets("yourworksheet").Range("b5").QueryTable.Refresh BackgroundQuery:=False or maybe for each ws in worksheets ws.querytable.refresh backgroundquery:=false next
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 Jul 17, 2003 #3 It is based on OLAP source data and according to MS Excel Help, background query is not applicable. Any other ideas?
It is based on OLAP source data and according to MS Excel Help, background query is not applicable. Any other ideas?