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

Chirag is an Independent Consultant at Patel Consulting, Chartered IT Professional, TOGAF9 Certified Architect and Microsoft Certified Solution Expert (Productivity, Data Platform) based in London, UK with more than 15 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 and Collab365. He is also one of the co-organisers of the SharePoint User Group UK (London) region. 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 every year participating in Charity bike rides and Duathlons. You can find him online at www.techchirag.com and follow Chirag on Twitter at @techChirag.

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

SharePoint Community

Categories
%d bloggers like this: