Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing external data
Sorry - Back again
Can anyone help with this? It probably is a one liner, but I have some code that does a lot of work but I need something that will refesh the external data. I have timed each time after some data is changed for it refresh and takes about 8 seconds. I have put a pause into the code of 12 seconds and still it doesnt want to work. Help greatly appreciated John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing external data
Maybe...
Rightclick on your data|query range and select Data Range Properties. Try changing the "enable background refresh" to off. In code, something like: worksheets("Sheet1").QueryTables(1).Refresh Backgroundquery:=false JohnUK wrote: Sorry - Back again Can anyone help with this? It probably is a one liner, but I have some code that does a lot of work but I need something that will refesh the external data. I have timed each time after some data is changed for it refresh and takes about 8 seconds. I have put a pause into the code of 12 seconds and still it doesnt want to work. Help greatly appreciated John -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing external data
Thank you Dave for your help.
Unfortunately it hasnt solved the problem. It has stopped the data box from appearing, but the code stops saying that it is refreshing in the background. I inserted a 12 second pause to give it time, but this still didnt work. Regards John "Dave Peterson" wrote: Maybe... Rightclick on your data|query range and select Data Range Properties. Try changing the "enable background refresh" to off. In code, something like: worksheets("Sheet1").QueryTables(1).Refresh Backgroundquery:=false JohnUK wrote: Sorry - Back again Can anyone help with this? It probably is a one liner, but I have some code that does a lot of work but I need something that will refesh the external data. I have timed each time after some data is changed for it refresh and takes about 8 seconds. I have put a pause into the code of 12 seconds and still it doesnt want to work. Help greatly appreciated John -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing external data
I don't work with queries, but you're getting a message that says that it's
refreshing in the background with that setting turned off?????? JohnUK wrote: Thank you Dave for your help. Unfortunately it hasnt solved the problem. It has stopped the data box from appearing, but the code stops saying that it is refreshing in the background. I inserted a 12 second pause to give it time, but this still didnt work. Regards John "Dave Peterson" wrote: Maybe... Rightclick on your data|query range and select Data Range Properties. Try changing the "enable background refresh" to off. In code, something like: worksheets("Sheet1").QueryTables(1).Refresh Backgroundquery:=false JohnUK wrote: Sorry - Back again Can anyone help with this? It probably is a one liner, but I have some code that does a lot of work but I need something that will refesh the external data. I have timed each time after some data is changed for it refresh and takes about 8 seconds. I have put a pause into the code of 12 seconds and still it doesnt want to work. Help greatly appreciated John -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing external data
Hi Dave,
I have tried with it turned on and off, and when I think it is refreshing in the background (because it says its refreshing down in the bottom left hand side of the screen) and no dialouge box appears, I got all excited, but the end result was if nothing happened. I think I will give up on this one or maybe run a macro manually each time after it refreshes. The macro basically copies the info into different tabs. Many thanks for your help Best regards John "Dave Peterson" wrote: I don't work with queries, but you're getting a message that says that it's refreshing in the background with that setting turned off?????? JohnUK wrote: Thank you Dave for your help. Unfortunately it hasnt solved the problem. It has stopped the data box from appearing, but the code stops saying that it is refreshing in the background. I inserted a 12 second pause to give it time, but this still didnt work. Regards John "Dave Peterson" wrote: Maybe... Rightclick on your data|query range and select Data Range Properties. Try changing the "enable background refresh" to off. In code, something like: worksheets("Sheet1").QueryTables(1).Refresh Backgroundquery:=false JohnUK wrote: Sorry - Back again Can anyone help with this? It probably is a one liner, but I have some code that does a lot of work but I need something that will refesh the external data. I have timed each time after some data is changed for it refresh and takes about 8 seconds. I have put a pause into the code of 12 seconds and still it doesnt want to work. Help greatly appreciated John -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing external data
I'm out of ideas.
Sorry. JohnUK wrote: Hi Dave, I have tried with it turned on and off, and when I think it is refreshing in the background (because it says its refreshing down in the bottom left hand side of the screen) and no dialouge box appears, I got all excited, but the end result was if nothing happened. I think I will give up on this one or maybe run a macro manually each time after it refreshes. The macro basically copies the info into different tabs. Many thanks for your help Best regards John "Dave Peterson" wrote: I don't work with queries, but you're getting a message that says that it's refreshing in the background with that setting turned off?????? JohnUK wrote: Thank you Dave for your help. Unfortunately it hasnt solved the problem. It has stopped the data box from appearing, but the code stops saying that it is refreshing in the background. I inserted a 12 second pause to give it time, but this still didnt work. Regards John "Dave Peterson" wrote: Maybe... Rightclick on your data|query range and select Data Range Properties. Try changing the "enable background refresh" to off. In code, something like: worksheets("Sheet1").QueryTables(1).Refresh Backgroundquery:=false JohnUK wrote: Sorry - Back again Can anyone help with this? It probably is a one liner, but I have some code that does a lot of work but I need something that will refesh the external data. I have timed each time after some data is changed for it refresh and takes about 8 seconds. I have put a pause into the code of 12 seconds and still it doesnt want to work. Help greatly appreciated John -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Formulas when refreshing data from external source | Excel Discussion (Misc queries) | |||
Import External Text Data and Refreshing Problem | Excel Worksheet Functions | |||
Refreshing external data breaks sorting of function columns | Excel Discussion (Misc queries) | |||
Query to external data not refreshing | Excel Discussion (Misc queries) | |||
Refreshing External Data on File Open | Excel Programming |