Unable to fetch data from web in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1338557%22%20slang%3D%22en-US%22%3EUnable%20to%20fetch%20data%20from%20web%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1338557%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Experts.%20I%20am%20using%20windows%2010%20and%20my%20subscription%20is%26nbsp%3B%20for%20Office%20Home%20%26amp%3B%20Student%202019.%3C%2FP%3E%3CP%3EIn%20any%20new%20excel%20file%20if%20I%20try%20to%20get%20data%20in%20my%20excel%20file%20from%20any%20website%20I%20get%20error%20as%20shown%20in%20attached%20screenshot.%20If%20I%20open%20a%20file%20that%20is%20already%20linked%20to%20website%20then%20also%20it%20won't%20fetch%20data%20from%20web%20and%20keep%20showing%20%22contacting%20the%20server%20for%20information.%20Press%20Esc%20to%20cancel.%22%20Until%20I%20press%20ESC%20Excel%20files%20remains%20stuck.%3C%2FP%3E%3CP%3EMicrosoft%20executives%20have%20tried%20uninstalling%20it%20completely%20and%20reinstalling%20Office.%20What%20should%20I%20do%3F%20Please%20help.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1338557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339813%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20fetch%20data%20from%20web%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339813%22%20slang%3D%22en-US%22%3EI'm%20guessing%20but%20it%20could%20be%20that%20your%20URL%20is%20too%20long.%20MAX%20256%20characters%20unfortunately.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20say%20Get%20Data%20from%20any%20website%2C%20are%20you%20using%20the%20Get%20Data%20(Power%20Query)%20process%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339827%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20fetch%20data%20from%20web%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339827%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20want%20to%20get%20this%20sorted%20follow%20this%20article%20link.....%3CA%20href%3D%22http%3A%2F%2Fwww.office365articlecenter.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ewww.office365articlecenter.com%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1340022%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20fetch%20data%20from%20web%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1340022%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%20It%20is%20not%20working%20with%20any%20url.%26nbsp%3B%20I%20am%20using%20the%20option%20%22from%20web''%20under%20the%20DATA%20tab.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1342652%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20fetch%20data%20from%20web%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1342652%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637251%22%20target%3D%22_blank%22%3E%40traderdevd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20guessing%20now%20as%20I%20don't%20know%20the%20answer%2C%20but%20you%20could%20try%20installing%20a%20different%20we%20browser%20and%20making%20it%20your%20default.%26nbsp%3B%20See%20if%20that%20helps.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Experts. I am using windows 10 and my subscription is  for Office Home & Student 2019.

In any new excel file if I try to get data in my excel file from any website I get error as shown in attached screenshot. If I open a file that is already linked to website then also it won't fetch data from web and keep showing "contacting the server for information. Press Esc to cancel." Until I press ESC Excel files remains stuck.

Microsoft executives have tried uninstalling it completely and reinstalling Office. What should I do? Please help.  

6 Replies
I'm guessing but it could be that your URL is too long. MAX 256 characters unfortunately.

When you say Get Data from any website, are you using the Get Data (Power Query) process?

@Wyn Hopkins  It is not working with any url.  I am using the option "from web'' under the DATA tab.

Hi @traderdevd 

 

I'm guessing now as I don't know the answer, but you could try installing a different we browser and making it your default.  See if that helps. 

 

@Wyn Hopkins hay the entire data off the web isnt being taken into the excel sheet

 

HIi@kumard6   would you mind starting another thread explaining your issues with screenshots and links to assist thanks

@kumard6 

 

I get options data from Fidelity using an export from them. They offer--and I'd be surprised if your brokerage (commodity brokerage?) doesn't offer something similar--either CSV or XLS formatted exports. Then just open the file (or import it) in Excel. No link needed through a URL..