New support for query tables on Excel Services improves the workbook, sharing in an organization

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 that your query table updated successfully. Select " Update " on the data Ribbon tab for desktop-Excel (2007, 2010 and 2013).

Make sure is, that your Excel Services configured to 2013, refresh external data, depending on whether the query table uses embedded or external data.

Publish your workbook with the query table to a SharePoint document library in 2013, and then viewing the query table on the file. The steps here , you can publish Excel workbooks on SharePoint.

Choose to see update, all connections to the most recent 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

View the original article here

OneNote Mobile for iPhone 1.1 adds new features, improves the user experience

[Editor's Note: this blog post was written by OneNote Mobile team member and technical writer of Mona Azarians.]

As the OneNote Mobile app for the iPhone in the United States made its debut in January, it has high in the free app and productivity classified categories in the iTunes app store have been.

Combined with the passion, the OneNote fans for their favorite product, many great proposals have enormous interest in the mobile app, and requirements have created. We have tackled some of this customer feedback into the latest upgrade to OneNote Mobile for iPhone, version 1.1, which is now available.

  

Delete unwanted notes and pages with others to share in e-Mail only even easier with
the OneNote Mobile 1.1 for iPhone version update, available now in the iTunes app store.

Whether you download OneNote for the iPhone for the first time, or upgrading your current app, some of the new features and improvements in version are here 1.1:

The ability to email your notes directly from your iPhoneAn easier way to get comments you delete no longer shroud more intuitive symbols and a home button, makes it easier to select or move between multiple NotebooksA sign-in scene and more simplified help synchronize with a Windows Live ID AccountFaster notebook and better overall app PerformanceA always more OneNote Mobile for iPhone help page in an easy to scan-FAQ-format

On the last element, The new OneNote Mobile for iPhone help page answers to your most the frequently asked questions - how you your mobile notes with OneNote notebooks synchronize on your computer now includes for example. You come to the help page from within the new app, go to settings, tap Help and support, and then tap on the first link on the screen.

Just for the record: the OneNote team reads all comments and reviews in the app store and the OneNote Forum on the Microsoft answers site, which is actively monitored the official support forum for all versions of OneNote, including OneNote Mobile. Their ongoing feedback helps us create a better app, so please Download this latest version and let us know what you think!

--Mona Azarians
 

View the original article here