Web Query in Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1071288%22%20slang%3D%22en-US%22%3EWeb%20Query%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1071288%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20web%20query%20to%20fetch%20data%20from%20the%20net%20with%20the%20refresh%20interval%20set%20at%201%20minute.%20When%20I%20open%20the%20file%20and%20click%20refresh%20button%20in%20data%20tab%2C%20it%20shows%20the%20following%20error%3A%3C%2FP%3E%3CP%3EData%20Source%20Error%3A%20The%20underlying%20connection%20was%20closed%3A%20An%20unexpected%20error%20occurred%20on%20a%20receive.%3CBR%20%2F%3EDetails%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnseindia.com%2Flive_market%2FdynaContent%2Flive_watch%2Fstock_watch%2FliveIndexWatchData.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fnseindia.com%2Flive_market%2FdynaContent%2Flive_watch%2Fstock_watch%2FliveIndexWatchData.json%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20a%20techie%20and%20do%20not%20know%20the%20programming%20codes.%20With%20my%20limited%20knowledge%20I%20just%20clear%20the%20permissions%20under%20data%20source%20setting%20tabs.%26nbsp%3BI%20do%20not%20know%2C%20how%20but%20after%20about%202%20hours%20or%20so%2C%20it%20starts%20working%20unless%20I%20shut%20down%20my%20computer.%20Shall%20appreciate%20if%20any%20permanent%20solution%20%2F%20settings%20is%2Fare%26nbsp%3B%20advised.%20I%20want%20to%20share%20this%20file%20with%20my%20friends%20also%20who%20should%20also%20use%20it%20uninterrupted.%26nbsp%3B%20Thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1071288%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1083374%22%20slang%3D%22en-US%22%3ERe%3A%20Web%20Query%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1083374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491169%22%20target%3D%22_blank%22%3E%40MadanMohanVerma%3C%2FA%3E%26nbsp%3BHi%20Madan%2C%20I%20am%20also%20looking%20for%20a%20solution%20to%20this%2C%20did%20you%20get%20a%20solution%20yet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1084002%22%20slang%3D%22en-US%22%3ERe%3A%20Web%20Query%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084002%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3ESeason's%20Greetings%20!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20still%20to%20get%20the%20solution....%3C%2FLINGO-BODY%3E
Highlighted
New 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?

Highlighted
Hi

Season's Greetings !

I am still to get the solution....