Microsoft Office Sharepoint

All my posts are provided "AS IS" with no warranties, and confer no rights.

Sharepoint Online External Users:

You always wanted to be able to allow users external to your company to collaborate on documents pertaining to common projects. You want to be minimize the administrative work that this requires. And, you want to do this in your Online environment. The solution is External Users Sharing. However, you also may have questions as… Read more

O365 Internet Explorer Protected Mode and security zones

One of the important settings often disregarded that can cause a lot of confusion as to whether the product behaves as expected or not: Internet Explorer Protected Mode and security zones when working in Office 365. Behaviour: You log-in to your Sharepoint site and notice that some of the resources are not properly working (for… Read more

Yes you can reach the developers directly.

We all knew that SharePoint online will be fast, better, will have new features deployed more rapidly than the on premise world , but what happened in the last weeks, months changed dramatically how the product looks, works , reacts. While this is simply mind blowing , the high number of new things to discover… Read more

Share a list externally ? Not directly.

Another gotcha for you: SharePoint Online has a great feature that enables your company to interact with external users, to better collaborate, without having to go through the whole process of adding user accounts, granting permissions, defining groups etc.. (not that you cannot do this of course, if you would like to take the matter… Read more

Modified By Column does not get updated

Have you ever seen the following behavior ? You create a new document library and start uploading content.Then the users start modifying the documents, however, the Modified by  field does not update to reflect the Name of the user that modified the document. Instead, the Name of the user that created ( or otherwise the… Read more

Getting the feature names available on the server

One script that comes in handy when you have the following type of issue ( rare but it happens ). Say you have deployed a webpart through a custom solution. From time to time on your load balanced farm, the page crashes . Investigating , you find out that the solution was not added on… Read more

Format SQL script

It has little to do with Sharepoint per se but I find it very useful to format the ugly scripts: And yes, it can be improved and refined. $s=Read-host "All in one line script" $s=$s.Replace(",",",`n").Replace("SELECT","`nSELECT").Replace("FROM","`nFrom").Replace("INNER","`n`tINNER").Replace("CASE","`n`t`tCASE").Replace("INSERT","`nINSERT").Replace("`n`n","`n") $s|out-file C:\temp\Formatted.sql  … Read more

List saved as template does not appear under Add an app or what lists can you save as template and use for creating other lists based on them.

You are trying to achieve the following : save a list as template, export the saved stp file and import it into a different environment to be able to create a new list based on this template. however, after importing it successfully, you discover that the list template is not displayed among the available templates… Read more

mpp files stored in SharePoint open read only in Project Client

Since I encountered this ever recurring question on our internal community sites and no clear explanation on it, here it is: Scenario: you have Microsoft Project Client installed and you create a new project. When saving, you decide to store the Project file (.mpp) in a SharePoint document list. You are able to successfully save the… Read more