Share via

Excel data from web login issues

Anonymous
2021-05-13T19:04:33+00:00

Hi there,

I'm trying out the "From Web" function in excel. I tried getting data from a website but did not select correct login options from the "Access Web content" dialog box. Now whenever I select "From Web" again and enter the same website, the "Access Web content" no longer shows up. How can I change the login credentials for this website? Excel must have saved my choices for this website somewhere.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-05-13T23:21:49+00:00

    Hi Joshua,

    Yes, Excel saves the site, so it is easier next time when we connect. If you want to remove the data source, please try the following method to clear permission in Excel:

    1. In Excel, click Data>Get Data>Data Source Settings, ensure Global permission radio button is selected, select the URL and click Clear permissions (if you want to clear all the sites at once, click arrow next to Clear permissions and choose **Clear all permissions).**Follow the steps shown in the screenshot below.
    2. Try connecting to the site again and check the result.

    Image

    Regards,

    Neha

    6 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-05-15T06:36:58+00:00

    Hi Joshua,

    Did you check the above reply? If you still need help, please update us.

    Regards,

    Neha

    0 comments
  2. Anonymous
    2021-05-17T23:22:16+00:00

    Hi Neha,

    Thank you for the help. This solved my problem! Very tricky to find these Data Source Settings.

    Thanks again!

    Josh

    0 comments