hi everyone, this is my first post. I have recently started to use excel, so im a newbie!
i am trying to run a web query where the required data i need is selected but i keep getting the following error:
"this Web query returned no data. To modify the query, click Ok, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar".
I have tried to edit query, but keep getting the error. Is their anyway i can retrieve this data? if not thru a web query is their another way that i can do this?
At the moment it takes too long to do it manually.
Thanks in advance.