I have a Web Query looking at a site for data, and it gets the table selection wrong. Viewing source of the linked to web page I am able to identify the correct table.
In an Excel Web Query you are able to save to an external .iqy file, and I can then edit that file replacing the correctly identified table, which works. However I would like the query to be stored inside of the Excel file, and not an external .iqy file.
How is it possible to access and edit the internal query of an Excel Web Query?
I forgot to mention I am using Excel 2003