I couldn't get the url to work past helloworld.com. So, where on the site
did you want to go and get info?
In general, you must import the table and then use a macro or an INDIRECT
formula to extract the info to another worksheet. You could put a refresh
macro in the Workbook_Open event of the ThisWorkbook module.

--
Don Guillett
SalesAid Software

"Dan" wrote in message
oups.com...
Using Excel 2003. I'm bringing in data from Sharepoint via IQY as
shown:

WEB1
SharePointApplication=http://www.helloworld.com:5060/_vti_bin
SharePointApplication=http://www.helloworld.com:5060/_vti_bin
SharePointListName={CD33EA8B-A0B3-4EAF-8BA3-C8BEAD289D5C}
SharePointListView={1B35BCF5-6842-4841-AC41-5D3D18B1676A}


This works great, if I 'double-click' the .iqy file, except I'd like to
take things a step further, but I'm having issues.

One, I'd like the data to come in as static data, not as a data range.
As a range I can't insert a row, sum a column, etc, without first
copying and pasting the data (values) to a second worksheet. Is this
possible, perhaps by way of add'l IQY properties? Excel settings?

Second, I'd like to save the query with the workbook, configured to
auto refresh when the workbook is opened. So, I set the Data Range
properties 'Refresh Data on File Open' and 'Remove External Data ...
Before Saving'. Then I save and close. Then I open, all looks good, but
then 'A connection to sharepoint site cannot be established'. So the
refresh fails. The sharepoint site requires authentication, BTW.
Appreciate feedback immensely. Thanks,

DAN