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?
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?
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:

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.
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.
Hi,
Is it possible to provide the web link and steps here? So that I can try to test it.
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.
3 people are following this question.
Modifying Office 2019 installation
Office 2019 - PerpetualVL2019 - Next planned update
Office 2019 - Will the Perpetual ProPlus version of office ever update beyond 1808? When?
MS Office 2019 VL - Click2Run Updates (size, download times)
<Add OfficeClientEdition="64" Channel="SemiAnnualPreview"> Does not install correct channel