| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Hybrid Mode
