This week we are highlighted as part of the SharePoint 2013 release some improvements in Excel Services. This post is brought to you by Prash Shirolkar, Program Manager on the Excel team.
Take a last look: the error message below is now a thing of the past.
With the improvements as part of the new Office, we support in Excel Services now refresh the query table. Workbooks with query tables now can seamlessly on the go will be updated from any browser! No need to convert query table to a pivot table or download of a workbook in Excel-desktop-client, to refresh the query table. In other words, the broad sharing of workbooks in the entire organization just got easier.
Ensure the desktop Excel (2007 or 2013) a workbook that contains a query table you and that it is connected to a data source. On the table, table, click the right mouse button on external data properties. If you have virtually no, follow the steps to create here .
Once you're connected, follow these 5 steps:
Guarantee you a link for 'Name' in the external data properties dialog box.
Make sure is, that your Excel Services configured to 2013, refresh external data, depending on whether the query table uses embedded or external data.
This is it! The query table is now updateable in the Excel Services deployment.
As always, we will continue to work to enhance Excel Services. One area that we do not yet support is refreshing a specific connection via "Update selected." That is something we are considering, but would love to you important hear in the comments, if this is something that you can find and use often.
Refreshing happy by query tables! Notify us of additional features that you would like to see in future versions.
-Prash Shirolkar, Excel program manager
No comments:
Post a Comment