Hello All,
First, thank you for view my question.
I am trying to link data from a website to excel, and have it automatically update, but it doesn't seem to be working. I have excel 2007.
1. I go to the "data tab",
2. click "from web",
3. paste the website I am trying to get data from into the "new web query",
4. check and uncheck the "hide icons" button (to have more options to check for import)
5. check the data want to import
6. click "import"
7. select the cell I want the data to go to, click ok
8. Error: "This web query returned no data. To change the query, click ok, click the arrow on the name box in the formula bar, click the name of the external data range for the web query, right-click the selection, and then click query."
Not sure what I am doing wrong here, or if it is simply a problem with the website. Does anyone have any insight or solutions to this?
First, thank you for view my question.
I am trying to link data from a website to excel, and have it automatically update, but it doesn't seem to be working. I have excel 2007.
1. I go to the "data tab",
2. click "from web",
3. paste the website I am trying to get data from into the "new web query",
4. check and uncheck the "hide icons" button (to have more options to check for import)
5. check the data want to import
6. click "import"
7. select the cell I want the data to go to, click ok
8. Error: "This web query returned no data. To change the query, click ok, click the arrow on the name box in the formula bar, click the name of the external data range for the web query, right-click the selection, and then click query."
Not sure what I am doing wrong here, or if it is simply a problem with the website. Does anyone have any insight or solutions to this?
