Get external data in excel from site with multiple logins
Posted on 2011-10-27
I'm using the Get External Data feature in excel 2007 to get data from a website. The website requires a login, but excel remembers my user and password. My problem is: I want to get the data from two different logins on the website, into two different sheets in my workbook. When I try to set it up, however, excel always uses the last login I used, and puts the same data into both worksheets. Can anyone help?