Hi All: I am trying to pull the data from a webpage into excel spreadsheet using the excel 2007. This website has login security and whenever you will go to the link , it will prompt you a security window to enter the username and password. The problem here is that I need to capture the data after every 30 minutes but whenever excel is trying to refresh the data, it get stuck at login screen and is not refreshing the data. Is there anyway I can bypass this login screen or is there any place where I can hard code the userid and password. This webpage is a intranet page and I need to capture some statistical data after every 30 minutes of time. If I leave the spreadsheet open, it is only prompting for first time and then it is regularly refreshing the data. Please advice...... Thanks, Rob