|
Modify settings and columns
|
|
|
Started: 5/11/2009 11:33 AM | |
|  | How to filter web part on multiple connections in a workbook? It is fine to use a filter web part to drive/filter out the other web parts such as Excel Web service, SSRS...on the same page on SharePoint.
However, I have a multiple connection on Excel workbook using Excel web service. When I try to make the connection between the filter web part (SQL Server 2005 Analysis service filter) and the Excel Web part with mulitple connections, it only allow my to choose one connection on the Excel workbook, therefore I can not refresh the all the contents from multiple connections in the Excel workbook.
Is there any workaround ? or is this a to-be-improve features in Sharepoint ?  |  |
|
| View in Web Browser | /_layouts/images/ichtmxls.gif | /_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1 | 0x0 | 0x1 | FileType | xlsx | 255 | | View in Web Browser | /_layouts/images/ichtmxls.gif | /_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1 | 0x0 | 0x1 | FileType | xlsb | 255 | | Snapshot in Excel | /_layouts/images/ewr134.gif | /_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&Snapshot=1 | 0x0 | 0x1 | FileType | xlsx | 256 | | Snapshot in Excel | /_layouts/images/ewr134.gif | /_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&Snapshot=1 | 0x0 | 0x1 | FileType | xlsb | 256 |
|
|
|