Web Query in Excel 365

Copper Contributor

I have created web query to fetch data from the net with the refresh interval set at 1 minute. When I open the file and click refresh button in data tab, it shows the following error:

Data Source Error: The underlying connection was closed: An unexpected error occurred on a receive.
Details:

https://nseindia.com/live_market/dynaContent/live_watch/stock_watch/liveIndexWatchData.json

 

I am not a techie and do not know the programming codes. With my limited knowledge I just clear the permissions under data source setting tabs. I do not know, how but after about 2 hours or so, it starts working unless I shut down my computer. Shall appreciate if any permanent solution / settings is/are  advised. I want to share this file with my friends also who should also use it uninterrupted.  Thanks.

 

2 Replies

@MadanMohanVerma Hi Madan, I am also looking for a solution to this, did you get a solution yet?

Hi

Season's Greetings !

I am still to get the solution....