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

Spence Harbars latest blog post (Antivirus and SharePoint 2013) is going through the different antivirus solutions for SharePoint 2013. The list of 3rd party vendors for this SharePoint is surprisingly small; only 1 vendor has a working solution and it is only in beta! Well at Todd Klindt's SharePoint Admin Blog, Todd talks shortly about this and his experience with antivirus and the need for an antivirus solution for a product as SharePoint in his weekly netcast found at Netcast 147 - Where Viruses Are

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

Problems with disabled accounts from former employees in your SharePoint User Profile Store ?

This will help you set up Exclusion Filters in the User Profile Synchronization


1) Browse to Central Administration Site > Manage Service Applications > User Profile Service Application.

2) On the Manage Profile Service: User Profile Service Application page, click the  Configure Synchronization Connections. This will take you to a page where all the synchronization connections are.

follow this excellent post from Spencer Harbar at (

He explains how to set up filters with the userAccountControl attribute from AD user object.


Tags: , , | Categories: Tips and tricks | SharePoint Configuration | SharePoint related

Accessing a SharePoint server from outside a network with a Forefront TMG.

The following 2 scenarios can give you an Internal Server Error

  • View properties on document
  • Editing a list view

Full error text:

Error Code: 500 Internal Server Error. The request was rejected by the HTTP filter. Contact the server administrator. (12217)



The reason why this happens is that the HTTP filter in Forefront has a URL protection mechanism wich will block URLs containing escaped characters after normalization.

To fix this:

  1. Open the properties of the firewall policy.
  2. Under the Traffic tab. Click Filtering
  3. Uncheck Verify normalization in the URL Protection section


Verify normalization will block URLs containing escaped characters after normalization.


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

Got the message:

>>The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document. <<


This is a challange and there is several possibilities:

Tags: , | Categories: SharePoint related