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

Chirag is an Independent Consultant at Patel Consulting, BCS Chartered IT Professional, TOGAF Certified Architect, Microsoft Certified Solution Expert (Productivity, Data Management and Analytics) and Microsoft Service Adoption specialist based in London, UK with more than 20 years of industry experience. He works with a wide variety of clients in many sectors, designing and implementing business collaboration, data and information management solutions and services based on SharePoint and Office 365 technologies to create business value for both themselves and their customers, including UK Microsoft Gold Partners with deployment, upgrade and migration services delivery. Chirag is an active SharePoint community participant, frequent speaker at local and international events including SharePoint Saturdays (London, Cambridge, Brussels, Paris, Madrid, Barcelona, UK, EMEA, India) and Collab365. In 2011, for his valuable contributions to Microsoft TechNet forums he received a Microsoft Community Contributor Award. In his little spare time he enjoys cycling, cricket and participating in Charity bike rides and Duathlons. You can follow Chirag on Twitter at @techChirag and find him online at www.techchirag.com

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Speaker at

Categories
%d bloggers like this: