Since the new User Profile Batch Update API is not available on all tenants yet I have been using the “User Profile Bulk Property Updater” from the OfficeDevPnP samples at

This bulk updates user profile properties in SharePoint Online through the use of a CSV file.

I am a big fan of Office 365 Developer Patterns and Practices and this sample is so usefull.


Here is the input format for the CSV fil to update your profiles with hiredate and birthday:





Tags: | Categories: SharePoint Configuration | SharePoint Development

Microsoft released the Service Pack 1 (SP1) for the 2013 set of Office products including Office 2013, SharePoint 2013 and Exchange Server 2013.

  • Office 2013 customers will begin to get notifications of SP1 availability through Windows Update within the next 30 days.
  • For Exchange Server 2013 and SharePoint 2013 you can use the links below.
  • If you are an Office 365 subscriber, you are always on the most up-to-date version

Here is an excel sheet of issues Fixed by Service Pack 1 (SP1) in Office and SharePoint 2013


SharePoint Server 2013


Service Pack 1 for Microsoft SharePoint Server 2013 (KB2817429)

Service Pack 1 for Microsoft SharePoint Server 2013 Language Pack (KB2817438)

SharePoint Foundation 2013


Service Pack 1 for Microsoft SharePoint Foundation 2013 (KB2817439)

Service Pack 1 for Microsoft SharePoint Foundation 2013 Language Pack (KB2817442)

SharePoint Designer 2013

Service Pack 1 for Microsoft SharePoint Designer 2013 (KB2817441) 64-Bit Edition

Service Pack 1 for Microsoft SharePoint Designer 2013 (KB2817441) 32-Bit Edition

Project Server 2013


Service Pack 1 for Microsoft Project Server 2013 (KB2817434)

Exchange Server 2013

Exchange Team Blog post on changes with the SP1

Microsoft Exchange Server 2013 Service Pack 1 (SP1)


Tags: , , , , | Categories: SharePoint

At last it is now possible to download a standalone SkyDrive Pro client.

The standalone SkyDrive Pro sync client allows users of SharePoint 2013 and SharePoint Online in Office 365 to sync their personal SkyDrive Pro and any SharePoint 2013 or Office 365 team site document libraries to their local machine for access to important content on and offline. The SkyDrive Pro sync client can be installed side-by-side with previous versions of Office (Office 2010, Office 2007, etc).

 Download SkyDrive Pro client for Windows

Tags: , , , , , | Categories: SharePoint related

Of course there is a print button in all Microsoft Office programs and even in Office Web App!

Well I thought so… But there is no print functionality in Office Excel Web App in the SharePoint Online.

The hunt begins:

Searching Microsoft Office Support

In search of the holy print button I found this at

There is a nice headline saying “Print an Excel workbook from the browser”, sounds good but it only gives us two possibilities:

  • By using the Print command in Internet Explorer
  • By opening the workbook in Excel, and using the Print features there

Well, nothing new there!

Office support excel print


Using the Browsers print button will give you a print with the toolbar on, not very useful. If using Excel on the computer is an option then this is for now the best choice.

Let’s take a look at the services offered with Office 365

Downloading and reading the Microsoft Office Web Apps Service Description.docx at gets me no further. Print is offered for Word and PowerPoint Web Apps but not in Excel.

SkyDrive has it

I was pretty surprised when I spotted the print button at the SkyDrive Excel Web App.

Comparison of the two Excel Web Apps in SkyDrive and Office 365:
SkyDrive Office 365
Excel_webApp_SkyDrive Excel_webApp_Office365

The print in Excel Web App in SkyDrive opens a new window with the workbook content and gives you the choices to print the active sheet or print selection.

But why not this functionality in Office 365?

Not coming soon

Reading the smoke signals from mount Redmond, the print in excel is nowhere in the recent roadmap for Office 365, telling me that we have to wait a couple of month, at least.

Tags: , , , | Categories: SharePoint related