Forum Discussion

Copper Contributor

Apr 26, 2020

Unable to fetch data from web in excel

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 atta...

excel

Excel for web

traderdevd

Copper Contributor

Apr 27, 2020

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

Wyn Hopkins

MVP

Apr 28, 2020

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.

kumard6
Copper Contributor
Feb 04, 2021
Wyn Hopkins hay the entire data off the web isnt being taken into the excel sheet
- mathetes
  Silver Contributor
  Feb 04, 2021
  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..
- Wyn Hopkins
  MVP
  Feb 04, 2021
  HIikumard6 would you mind starting another thread explaining your issues with screenshots and links to assist thanks