Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with QueryTable.Refresh Causing CPU to Spike to 100%
Hello Gurus,
I have a an issue with what appears to be the QueryTable.Refresh. I am hoping someone else has experienced this issue and has a resolution. I have a excel spreadsheet that pulls in data from a web query data source. This works fine 90% of the time and retreives the data in less than 20 seconds. The problem that i am facing is that 10% of the time, the query appears to hang or become disconnected. This hang causes the CPU to Spike 100% and all other applications to become in-operable. The only option is to kill the excel process from the task manager. Has anyone experienced this or something similar and are there any workarounds or patches that can be applied? Thanks for your expertise, Dax Sheet3.Range("A1").QueryTable.Refresh BackgroundQuery:=False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh Query Table causing debug error with Background Refresh pr | Excel Programming | |||
QueryTable Refresh Failed | Excel Programming | |||
QueryTable Last Refresh Date? | Excel Programming | |||
I need a QueryTable.Refresh solution | Excel Programming | |||
catching cancel on QueryTable.Refresh | Excel Programming |