Excel 2003 and XP Pro.
I have a worksheet populated via web query, and I'd like to prevent users from seeing or updating the query's URL.
I used the "Data...Import External Data...New Web Query" menu, and pasted my URL.
If I password-protect the sheet, it prevents users from seeing / updating the query, but it also doesn't refresh the data. And in the error message saying it can't refresh, it shows the URL!
Is there a way to hide a web query, yet allow the refresh?