Here's what i do in Excel 2010

- Go to data tab
- Get External Data -> From Text
- Under filename I put the following website http://www.gw2spidy.com/api/v0.9/csv/all-items/all
- Hit Okay
- It works however it prompts me for password a couple times when you don't need them

Is there a way to stop the password prompting? As I'd like to be able to easily auto refresh this but the password prompt doesn't allow this to work.

Thanks in advance