D
Dax
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
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