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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com