Webinar: Organization charts in PowerPoint and Visio

AppId is over the quota
AppId is over the quota

Need to create an org chart? Unsure of whether to use PowerPoint or Visio? In this week's webinar, we'll show you both ways and the advantages of each depending on your audience, plus we'll share tips and best practices for creating organization charts. A video of the webinar will be posted shortly after the webinar.

What you will learn at Tuesday's webinar

How to decide between using PowerPoint or Visio How to make an org chart in PowerPoint (or any Office program really) How to make an org chart in Visio

References for this webinar

Learn how to join us each week or watch previous webinars at http://aka.ms/offweb.

--Doug Thomas

View the original article here

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