question

AnshulBansal-9163 avatar image
0 Votes"
AnshulBansal-9163 asked ·

Authenticate credentials while importing data

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-itprooffice-deployment
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered ·

Hi @AnshulBansal-9163,
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.






320.png (16.5 KiB)
· 4 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
emizhang-msft avatar image emizhang-msft AnshulBansal-9163 ·

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

0 Votes 0 ·

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.

0 Votes 0 ·
Show more comments