Authenticate credentials while importing data

Anshul Bansal 21 Reputation points
2021-03-01T04:39:26.78+00:00

I am Importing data from web to excel sheet and keeps automatic refreshing at every 5 mins. while every time before refreshing, it asks to authenticate the credentials. how can i solve this?

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,000 questions
0 comments
Accepted answer
  1. Emi Zhang-MSFT 21,856 Reputation points Microsoft Vendor
    2021-03-02T10:35:05.217+00:00

    Hi @Anshul Bansal ,
    What version of Excel did you use?
    How did import data from web to Excel? Did you use Power Query or From Web feature?
    Do you need to enter the password to open the web?
    I suggest you try to use Power Query to create the connection from Web, in Power Query you can select the authentication method to create the connection:

    73422-320.png

    You can also refer to this article:
    https://exceloffthegrid.com/power-query-import-data-from-the-web/

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest