New support for query tables in Excel Services improves workbook sharing across an organization

re: New support for query tables in Excel Services improves workbook sharing across an organization

dlooney1 — Wed, 20 Mar 2013 23:39:23 GMT

The link provided for creating a data source doesn’t work as it appears to be out dated as follows:

Step 2 works as stated but step 3 says to “Select the connection that you want, and then click Open”. However that’s not the flow. The wizard first requires you to select “the kind of data source to connect to” followed by additional questions.

I’m trying to use an existing Excel 2013 workbook as my data source (on my local drive just to keep things simple for learning.) Despite extensive web searching I can’t figure out what the proper connection type is (it appears to be Other/Advanced and one of the OLE DB providers) but which one and what the connection string needs to be has proven elusive.

Providing this information would be greatly appreciated.

re: New support for query tables in Excel Services improves workbook sharing across an organization

Ethan Sath — Wed, 13 Mar 2013 12:35:41 GMT

hi office.com

re: New support for query tables in Excel Services improves workbook sharing across an organization

Craig Hatmaker — Thu, 07 Mar 2013 18:11:21 GMT

Nice. Thanks

re: New support for query tables in Excel Services improves workbook sharing across an organization

Alex Porter — Wed, 06 Mar 2013 00:22:21 GMT

My biggest request is importing an O365 SharePoint list into Excel's Data Model (PowerPivot) via OData feed. If you try it in PowerPivot you get a 403 error. There's a way to get it in via the Excel data import but it's roundabout and leads to other problems.

re: New support for query tables in Excel Services improves workbook sharing across an organization

Sarah — Fri, 22 Feb 2013 15:25:48 GMT

I really love this feature I can write entire query to retrieve data on the fly via browser with excel services ..

just absolute classic feature.

please browse for

<a href="http://www.sqlservermanagementstudio.net"> Sharepoint</a>

Sarah

re: New support for query tables in Excel Services improves workbook sharing across an organization

silvestru — Thu, 21 Feb 2013 18:10:03 GMT

is the best

<a href=www.computerbild.de/.../SoundFrost-8118785.html >youtube converter</a>

re: New support for query tables in Excel Services improves workbook sharing across an organization

Frederic Forest — Thu, 21 Feb 2013 13:16:02 GMT

Thanks for the info. Well, truth being told I didn't expect this to work quite yet. :) Still is my #1 requested feature for SPO tho. It would allow users to make their own, decently powerful, data visualisation solutions with very little expertise.

re: New support for query tables in Excel Services improves workbook sharing across an organization

Carlos Otero — Wed, 20 Feb 2013 20:23:15 GMT

Hi Frederic, it looks like you have a query table comprising external data from a SharePoint List. Refreshing such a Query Table is supported in SharePoint 2013, however “SharePoint Lists” themselves remain an unsupported feature in Excel Services 2013, hence you will need to open the workbook in client to refresh..

That said, for SharePoint On-line (SPO) you still need to open workbook in desktop Excel client to refresh this Query Table, because external data access is not yet supported in SPO.

re: New support for query tables in Excel Services improves workbook sharing across an organization

Frederic Forest — Tue, 19 Feb 2013 13:00:34 GMT

One of the main data flow we use with SharePoint (SPO in our case) is

SharePoint list >> Excel table >> Excel Pivot table/graph >> Excel Services.

This allows us to quickly visualize the content of a list right within SharePoint. Our only drawback at this point is that we need to manually open the workbook to refresh the data, which is not that optimal.

Are we to understand that with this new update, that workflow in SP-2013 (or SPO-2013) will be fully supported without the need to open the client app?

Tx!