password protected page not opening by web query
 

i created a web query for accessing a password protected page. now after
closing and restarting excel, that query says -"web query did not return any
data" if i again create the query the data comes. switching excel off makes
it forget the password-so how do i put it in memory?