Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Data from Sharepoint
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
Excel links & SharePoint 3.0 (worked fine with SharePoint 2.0) | Excel Discussion (Misc queries) | |||
linking data from sharepoint to excel spreadsheet? | Excel Worksheet Functions | |||
Retrieve xml data from SharePoint | Excel Worksheet Functions |