I'm at a loss. I'm trying to pull a table from a company website into Excel that requires user log in and password. Get Data From Web does not work as Excel never accepts any log in credentials I've ever typed in (for any website, very frustrating). I've pulled data from other websites using the Legacy wizard successfully. When I try to use the Legacy wizard on this website, the log in button does nothing after I enter the credentials. I have also tried both checking and not checking the box under the login button to see if that was throwing off the Legacy wizard. Any ideas?
This is the error I get immediately upon loading into the Get Data from Web (Legacy) tool. Whether I click "Yes" or "No" it does not change the outcome.