Can you explain a little bit what you are trying to do? Will you be continuing to work on your machine during this time? Will there be other applications running also? If you tie up the CPU with this process, is that a problem? Good Luck!
nah no problem if it ties up machine its so it can be going in the background, i may use a internet browser sometimes but it dosnt matter to much how many resources it uses... i know you cant do much while its going its so that i can leave a sheet refreshing so that if data changes on a site then it records the exact time it happened so while im away from keyboard i can open it and leave it monitoring
If the source of your data is from a web site and you've used the Website import wizard found on the Data toolbar then the refresh time is a built in property of the import.
Eg. Once you've set up your import data sheet just "right click" on sheet and select "Data Range Properties" from the drop down menu. In the "properties window you can set how ofter you want the refresh to occur.