Authenticate credentials while importing data

Question

Authenticate credentials while importing data

Anshul Bansal 21

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?

Accepted answer

0 additional answers

Your answer

Answer 1

Emi Zhang-MSFT 30,046 Microsoft External Staff

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:

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.

Anshul Bansal 21 Reputation points

2021-03-03T04:38:57.85+00:00

Thanks for helping me.
I use Excel 2016. Import data from web feature and do not enter any passwords as it is a public available
data.
The same above screenshot i used to get every time.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-03-03T05:00:59.077+00:00

Hi,
Is it possible to provide the web link and steps here? So that I can try to test it.
Anshul Bansal 21 Reputation points

2021-03-03T19:32:41.96+00:00

Link - https://www.nseindia.com/option-chain
Steps: 1) Data<From web<advance editor<Copied the URL (taken from inspect, then network, then refresh, then took the URL from there).
2) under headers, I added language, user agent, cookies
3) then customize the columns thn close and load.
4) Then automatic refresh after every 5 min.
Anshul Bansal 21 Reputation points

2021-03-03T19:35:08.183+00:00

In my understanding, there is problem in importing the right cookies from web to excel. I worked a lot on it. but not able to fix it.

Share via

Authenticate credentials while importing data

0 additional answers

Your answer