Unable to create SharePoint Online site with MobileExcelWebAccess feature error

This week there was an issue with creating SharePoint Online sites in our tenant as reported in Office 365 Tenant Message Centre for also other customers. There is a forum thread on this issue at the new Office 365 Network and thought I quickly blog this for those who are hitting this issue.

The issue was relating to a site template error, specifically in our case, it was when we were trying to create a project and its associated SharePoint site in Project Online. The error was:

image

So I had a look at Site collection features and site features settings and nothing was there. Having logged a support ticket with Microsoft they acknowledged the issue and their response subsequently was that the MobileExcelWebAccess feature is deprecated.

So as a workaround to fix the issue Microsoft provided the following powershell script to run which resolves the issue. The actual script is at the end of this post. You will need to install the following prerequisites before you run the script or ask your SharePoint Administrator.

1) Install SharePoint Online Management Shell from the below download link

https://www.microsoft.com/en-us/download/details.aspx?id=35588

 

2) Install The SharePoint Online Client Components SDK from the below download link

https://www.microsoft.com/en-in/download/details.aspx?id=42038

clip_image002

Hope this helps.

-Chirag

POWERSHELL SCRIPT

$host.Runspace.ThreadOptions = “ReuseThread”

#Definition of the function that allows to enable a SPO Feature
function Enable-SPOFeature
{
param ($sSiteColUrl,$sUserName,$sPassword,$sFeatureGuid)
try
{
#Adding the Client OM Assemblies
Add-Type -Path “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll”
Add-Type -Path “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll”

#SPO Client Object Model Context
$spoCtx = New-Object Microsoft.SharePoint.Client.ClientContext($sSiteColUrl)
$spoCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($sUsername, $sPassword)
$spoCtx.Credentials = $spoCredentials

Write-Host “—————————————————————————-”  -foregroundcolor Green
Write-Host “Enabling the Feature with GUID $sFeatureGuid !!” -ForegroundColor Green
Write-Host “—————————————————————————-”  -foregroundcolor Green

$guiFeatureGuid = [System.Guid] $sFeatureGuid
$spoSite=$spoCtx.Site
$spoSite.Features.Add($sFeatureGuid, $true, [Microsoft.SharePoint.Client.FeatureDefinitionScope]::None)
$spoCtx.ExecuteQuery()
$spoCtx.Dispose()
}
catch [System.Exception]
{
write-host -f red $_.Exception.ToString()
}
}

#Required Parameters
$sSiteColUrl = “site collection URL”
$sUserName = “user name”
$sFeatureGuid= “e995e28b-9ba8-4668-9933-cf5c146d7a9f”
$sPassword = Read-Host -Prompt “Password” -AsSecureString
$sPassword=convertto-securestring “Password” -asplaintext -force

Enable-SPOFeature -sSiteColUrl $sSiteColUrl -sUserName $sUserName -sPassword $sPassword -sFeatureGuid $sFeatureGuid

Advertisements
Tagged with: , ,
Posted in Office 365, SharePoint

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Speaking Engagements

SharePoint Saturday Belgium 2017
21 October 2017

SharePoint Saturday Barcelona 2017
28 October 2017

Collab 365 Global Conference 2017
1-2 November 2017

Categories
%d bloggers like this: