Hi,

I've been trying to get excel 2007 to do an web query using an iqy file and
this piece works.

However if I then select the data and try and format as a table it gives the
following warning:

Your selection overlaps one or more external data ranges.
Do you want to convert the selection to a table and remove all external
connections?

If I select yes it breaks the external connections and the data is not
refreshable.

Is it possible to have an external query and to get its data into a table?
Doing so makes it much easier to manipulate the data into a pivot table etc

I'm not sure how they do it but the SharePoing list action "Export to
Spreadsheet" does something similar to what I want to do.

Thanks

Donal