Thursday, April 30, 2015

This page is not using a valid page layout. To correct the problem, edit page settings and select a valid page layout.

Problem:
We had a requirement to copy few web part pages from Staging environment to production. Achieved it with "Content Deployment Wizard" tool. However, copied pages gave this error message:
"This page is not using a valid page layout. To correct the problem, edit page settings and select a valid page layout."
This page is not using a valid page layout. To correct the problem, edit page settings and select a valid page layout.

Solution:
Root cause of the problem is: Page layout URLs are hard-coded in the publishing/web part pages. When you copy/move them from one site to another (or during export-import).

Solution is: You'll have to update it. Here is the easiest way:
  1. Open you site in SharePoint designer, Navigate to the library (usually: Pages), Right click on your copied page, choose "Detach from page layout"
  2. Now, again right click on the page and choose "Reattach to Page Layout". Ignore any error it throws.
This should fix your problem. If you have a bunch of files to update page layout, You can use PowerShell. Here is my PowerShell script to update page layout property of pages: How to Change Page Layout in SharePoint 2013 using PowerShell

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Saturday, April 25, 2015

Fix for "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'"

Problem:
When trying to navigate to a content source or crawl history in SharePoint 2013 search service application, received this error message "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'"
Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'

Solution: Enable and run the timer job "Search Health Monitoring - Trace Events" once!
Here is the step by step solution:
  • Navigate to SharePoint 2013 Central Administration
  • Click on "Monitoring" >> Review Timer job definitions
  • Pick ""Search Health Monitoring - Trace Events" timer job by navigating to the next page in the list.
  • Click on "Enable" button if its not enabled already. Once enabled, Click on "Run Now" button for the same timer job.
  • Give it a minute to run. Once Ran, This issue should be gone away!


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Add a Link to SharePoint Top Navigation Menu or Quick Launch using PowerShell

Requirement: Add a new link to SharePoint Global Navigation (Top Link Bar) or Quick Launch using PowerShell.

Add link to SharePoint Top Navigation using PowerShell:
Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue

#Variables for processing
$WebURL="http://sharepoint.crescent.com/teams/marketing"
$NavigationTitle="Employee Profile"
$NavigationLink="https://peoplesoft.crescent.com/employee/profile.aspx"

#Get the Web
$Web= Get-SPWeb $WebURL

#Get Top Navigation
$TopNavigation = $Web.Navigation.TopNavigationBar
#For Quick Launch, Use: Navigation.QuickLaunch

#Create a New Top Navigation Node
$node = New-Object Microsoft.SharePoint.Navigation.SPNavigationNode($NavigationTitle, $NavigationLink, $true)

#Add the Node
$TopNavigation.AddAsLast($node)

#Set the Target Property - Will work only when Publishing features is enabled
$node.Properties["Target"] = "_blank"

$node.Update
You can alter the script to add new link to all sites in a site collection.

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


How to Create a Web Part Page in SharePoint 2013

To create a web part page in SharePoint 2013, Follow these steps:
  • Go to your SharePoint site, Navigate to "Site Pages" library - Click on "Site Contents" link from Left navigation >> Click on "Site Pages" library. 
  • Go to the "Files" tab, expand the New Document drop-down list and click on the "Web Part Page"how to add a new web part page in sharepoint 2013
  • Enter the Name for your new web part page, select the page Layout and Save Location, and then click on Create button. create new web part page sharepoint 2013
  • This creates a blank web part page in SharePoint 2013 as shown below. Now, We'll have to add some relevant web part to this web part page. Click on "Add a web Part" link shown in web part zoneshow to add a new web part page in sharepoint 2013
  • Select the relevant Web part to insert and click on "Add" button. I've added "Excel Web Access" web part. create a blank web part page in sharepoint 2013
  • Configure web part properties. In my case, I've specified the excel sheet to display in the Excel web access web part. how to create web part page sharepoint 2013
  • Click on "Stop Editing" button from ribbon to Save the page. That's all. We've added a new web part page in SharePoint 2013.
Choosing "Add a page" from Site settings menu, creates a Wiki Page!


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Friday, April 24, 2015

Cannot navigate to the requested page while user profile synchronization is running. Please wait for the current synchronization run to finish.

Problem: When you try to start the Profile synchronization or try to create a new connection in User profile service application in SharePoint 2013, It gives this error message:

"Cannot navigate to the requested page while user profile synchronization is running. Please wait for the current synchronization run to finish."
Cannot navigate to the requested page while user profile synchronization is running. Please wait for the current synchronization run to finish.
Solution:
Generally, when a profile synchronizing is running, You may get this error message. If you find its running for long time, simply use the "Stop" link to stop the current synchronization job.

Here is how:
  • Open the SharePoint 2013 Central Administration >> Manage Service applications
  • Open User Profile Service application
  • Click the "Stop" link under "Profile Synchronization Settings" section. 
What if you don't find "Stop" link? Well, that's because you don't have any user profile synchronization job running! So, what is the fix? Stop and Start the "User Profile Synchronization Service" from Services on the server page!
start user profile synchronization service in sharepoint 2013
Use this post, if you face any trouble in starting user profile sync service: User Profile Synchronization Service Stuck at "Starting" - Solution

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Thursday, April 23, 2015

Sorry, we couldn't find your license to use this feature. If you know who manages the licenses for your organization, tell them you'd like a license to use 'Excel Services'.

Problem: 
SharePoint Excel Services failed with an error message: "Sorry, we couldn't find your license to use this feature. If you know who manages the licenses for your organization, tell them you'd like a license to use 'Excel Services'."
Sorry, we couldn't find your license to use this feature. If you know who manages the licenses for your organization, tell them you'd like a license to use 'Excel Services'.

Solutions:


Make Sure SharePoint Enterprise Feature is enabled
Excel Services is part of SharePoint Enterprise feature in SharePoint 2013. So, Make sure "SharePoint Server Enterprise Site Collection features" is enabled both at site level and Site collection levels. If activated already, Try Deactivate-Activate again!

Have you upgraded from Standard to Enterprise? Enable Features on Existing sites!
When SharePoint Server license is upgraded from Standard to Enterprise, it applies only to new sites we are going to create. For existing sites, we must use "Enable Features on Existing Sites" feature once, under "Upgrade and Migration" in SharePoint 2013 Central Administration site.

SharePoint 2013 User Licensing is Enabled?
Another cause and solution is: If you have enabled SharePoint User Licensing to restrict Enterprise edition features or Office web apps edit, You have to add mapping to "Enterprise" license and add the user in appropriate AD security group! Refer: SharePoint 2013 User Licensing Enforcement

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


How to Configure Excel Services in SharePoint 2013 - Step by Step

SharePoint 2013 enterprise edition offers Excel Services service application that enables browser-based rendering of Excel workbooks. Not just for rendering, but its primary used in business intelligence scenarios for its excel calculation & analysis capabilities, ability to query external data sources, etc. Lets walk-through the steps of configuring Excel Services to SharePoint Server 2013 farm.

How to Configure Excel Services in SharePoint 2013:
Here are the steps in high-level to configure Excel Services
  • Start Excel Calculation Services Service Instance
  • Create Excel Services Service Application
  • Grant Database Access to Excel services service Account 
  • Suppress Office Web Apps to enable Excel services 
  • Configure trusted file location.
Prerequisites - We need a managed account for Excel Services service application. Create a new managed account if you don't have one configured already!. Configuring Managed Accounts in SharePoint 2013

Step 1: Start Excel Calculation Services Service Instance:
Excel Services application relays on excel calculation service. To start the excel calculation service, Navigate to
  • Central Administration >> System Settings >> Manage Services on server
  • Select the server where you want to start the Excel Services. Typically, this will be one of your application server. You can run it on multiple servers for better performance and availability.
  • In the services list, Click on "Start" link next to "Excel calculation services"
excel services sharepoint 2013 configuration
Once its been started, the next step is to create an Excel Services service application.

Step 2: Create Excel Services Service Application
Here is how to create new "Excel services" service application
  • Go to Central Administration >> Application Management >>  Manage service applications
  • Click "New" button and select "Excel Services Application"install and configure excel services sharepoint 2013
  • Enter the Name of your excel service application in create new excel service application page.
  • Select "Create new application pool" option, enter the application pool name.
  • Select the "Configurable" option and specify the service account to run the application pool. This will be a managed account registered already in your farm.
  • Remember to Select "Add this service application's proxy to the farm's default proxy list." 
  • Click on "OK" button to create new excel services service application.sharepoint 2013 excel services step by step

Step 3: Grant Database access to "Excel Services" Service Application's service account.
The Excel Services application pool account must be granted access to SharePoint content databases. This can be done either by directly from SQL Server management studio or with PowerShell.

Grant Database access to Excel Services Application Pool account with PowerShell:
$WebApp = Get-SPWebApplication "http://intranet.crescent.com"

$WebApp.GrantAccesstoProcessIdentity("Crescent\SP13_ServiceApps")

Which grants "SPDataAccess" Membership roles on all content databases of the Web Application to the Service Application App Pool account! Please note, You must rerun these cmdlets, If you add new content databases in future!

Step 4: Suppress Office Web Apps to enable Excel services
If office web apps is enabled for your SharePoint environment, You must suppress it for Excel files in order to enable Excel services. Run these cmdlets to suppress Excel Office Web Application.
New-SPWOPISuppressionSetting -Extension "XLSX" -Action "view"

New-SPWOPISuppressionSetting -Extension "XLS" -Action "view"

#To Check current suppression settings: Get-SPWOPISuppressionSetting
#To Revert : Remove-SPWOPISuppressionSetting -Extension "XLSX" -Action "view"
#Remove-SPWOPISuppressionSetting -Extension "XLS" -Action "view"
From now on, opening any Excel file in SharePoint should launch Excel Services, instead of Excel Web Apps. Watch out the URL when you launch any Excel file from SharePoint. It should be something like "/_layouts/15/xlviewer.aspx" Instead of "/_layouts/15/WopiFrame.aspx"

Step 5: Configure Trusted File Locations
The final step to complete configuring Excel services is to add trusted file location. Here is how:
  • Navigate to Central Administration >> Application management >> Click on "Manage Service Applications" link
  • In the Manage service applications page, click on the Excel Services service application that we created.
  • From "Manage Excel Services Application" page, click on "Trusted File Locations" link.
    configure excel services in sharepoint 2013
  • Click on "Add Trusted File Location". In the Address column, Enter the URL of your SharePoint Site/Library. Set other options accordingly.
  • Click "OK" to save your changes.
Test everything works as expected!
So now, we've finished configuring Excel Services for SharePoint 2013. Lets test it out.
  • Go to any of your SharePoint site with "Enterprise Features" turned ON. Click on "Edit page" from Site Actions gear. 
  • Click on Insert >> Web part >> Select "Excel Web Access" web part.
  • Set the web part properties to fetch any Excel file from SharePoint document library location.
  • Save and Publish the page. You should see the Excel file rendering in the web part.
Technet article: Overview of Excel Services in SharePoint Server 2013

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Sunday, April 19, 2015

How to Remove a Column from SharePoint List using PowerShell

Requirement: User created a calculated column with error in its formula! That caused the list view web part to crash! couldn't remove the column from SharePoint list using web UI.

Solution: PowerShell script to delete the column from SharePoint list!
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
 
#Variables
$SiteURL="http://intranet.crescent.com/" 
$ListName="Change Request"
$ColumnName="Activity Status"

#Get Internal Name of the columns
$web = Get-SPWeb $SiteURL

#Get the list
$list = $web.Lists.TryGetList($ListName)

if($List -ne $null)
{
    #Get the column 
    $column = $list.Fields[$ColumnName]

    if($column -ne $null)
    {
        #Reset column properties to allow delete
        $column.Hidden = $false
        $column.ReadOnlyField = $false
        $column.AllowDeletion = $true
        $column.Update()

        #Delete the column from list
        $list.Fields.Delete($column)
        write-host "Column has been deleted!" -f Green
    }
    else
     {
        write-host "Specified column name not found!" -ForegroundColor Red
     }
}

Bulk remove columns from SharePoint list using PowerShell:
To make it reusable, lets wrap the code inside a function and call, to bulk delete columns from SharePoint list. 
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Custom Function to delete a column with PowerShell
Function Remove-Column($WebURL, $ListName, $ColumnName)
{

    #Get Internal Name of the columns
    $web = Get-SPWeb $WebURL

    #Get the list
    $list = $web.Lists.TryGetList($ListName)

    if($List -ne $null)
    {
        #Get the column 
        $column = $list.Fields[$ColumnName]

        if($column -ne $null)
        {
            #Reset column properties to allow delete
            $column.Hidden = $false
            $column.ReadOnlyField = $false
            $column.AllowDeletion = $true
            $column.Update()

            #Delete the column from list
            $list.Fields.Delete($column)
            write-host "Column '$ColumnName' has been deleted!" -f Green
        }
        else
        {
            write-host "Specified column name not found!" -ForegroundColor Red
        }
    }
    else
    {
        write-host "Specified List is not found!" -ForegroundColor Red
    }
}

#Variables
$WebURL="http://intranet.crescent.com" 
$ListName="Change Request"

#Array to hold column titles
$ColumnNames=@("Change Type","Approvers","Proposed Date and Time")

#Process each column
$ColumnNames | foreach {

    #Call the function to remove column
    Remove-Column $WebURL $ListName $_
}


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Friday, April 17, 2015

Get All Site Collections Size (Storage Used, Allocated), Owners, Database Details with STSADM

Do you know the STSADM command line tool can do this still in SharePoint 2013? Yes! it can get you the quick peek view of all site collections in the given web application. It gets you details such as:
  • Storage space allocated - Storage used, warning and maximum levels
  • Site collection GUIDs
  • Site collection database names
  • Primary and Secondary Owners
Simply trigger command line and run: 
Stsadm -o EnumSites -url http://Sharepoint-web-app-URL 

This command line retrieves all details as listed above in XML format. Lets export that XML to a file and get it in Excel for better analysis. Run:
Stsadm -o EnumSites -url http://Sharepoint-web-app-URL > SitesInfo.xml 

Once completed, Open the XML file in Microsoft Excel, choose "As an XML Table"
and you should get the table as below:

PowerShell script to get site collection size: How to check site collection size in SharePoint 2013 with PowerShell

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Thursday, April 16, 2015

Reset SharePoint List View Filters with PowerShell

Requirement: Reset SharePoint view filters.

Solution: To reset SharePoint view in bulk, we can use this PowerShell script.

PowerShell script to reset SharePoint view.
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$WebURL = "http://sales.crescent.com"
$ListName = "Proposal Documents"
$ViewName = "All Proposals"  
 
#Get the Site, List and View objects
$web = Get-SPWeb $WebURL
$List = $Web.Lists[$ListName]
$View = $List.Views | ? {$_.title -eq $ViewName}

#Reset SharePoint View - By default sort by Name
$View.Query = "<OrderBy><FieldRef Name='FileLeafRef' /></OrderBy>" 
$View.Update()
$List.Update()
This script removes Sorting and Filters applied to the given SharePoint list view.

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Monday, April 13, 2015

Fix "We're having a problem opening this location in file explorer. Add this web site to your Trusted Sites list and try again" Error in SharePoint

Problem: 
SharePoint 2010 explorer view gives this error message: "We're having a problem opening this location in file explorer. Add this web site to your Trusted Sites list and try again"
Solution:
Most of the time, simply adding your SharePoint site URL to the Trusted Sites zone doesn’t solve the problem! Try these solutions instead:
  • Check whether web client service is in started state under services console (services.msc). If its windows Server, You'll have to install "Desktop Experience" from Add Roles and Features.
  • If you are in IE10, Try this hot fix: https://support.microsoft.com/en-us/kb/2846960


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Friday, April 10, 2015

How to Deploy Multiple WSP Solutions using PowerShell in SharePoint

Requirement: Have a bunch of WSP solution packages and had to add and deploy all of them to a cloned SharePoint environment.

Solution: Lets bulk deploy all WSP solutions from a folder to SharePoint using PowerShell.

PowerShell script to bulk add Multiple solutions:
Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue

Function WaitForInsallation([string] $SolutionName)
{
        Write-Host -NoNewline "Waiting for deployment job to complete" $SolutionName "."
        $WSPSol = Get-SPSolution $SolutionName
        while($wspSol.JobExists)
        {
            sleep 2
            Write-Host -NoNewline "."
            $wspSol = Get-SPSolution $SolutionName
        }
        Write-Host "job Completed" -ForegroundColor green
}

Function Deploy-SPSolution ($WSPFolderPath)
{
    #Get all wsp files from the given folder
    $WSPFiles = Get-childitem $WspFolderPath | where {$_.Name -like "*.wsp"}

    #Iterate through each wsp and Add in to the solution store
    ForEach($File in $wspFiles)
    {
        $wsp = Get-SPSolution | Where {$_.Name -eq $File.Name}

        if($wsp -eq $null)
        {
            write-host "Adding WSP solution:"$File.Name
            Add-SPSolution -LiteralPath ($WspFolderPath + "\" + $file.Name)
        }
        else
        {
            write-host "solution already exists!"

        }
    }
}

try
{
        Deploy-SPSolution "C:\WSPFiles"
}
catch
{
    write-host $_.exception
} 
Once added to the SharePoint solution store, You can either deploy them to the targeted web applications/globally using PowerShell,
Install-SPSolution -Identity "Solution-Name" -Webapplication "Web-App-URL" -GacDeployment -Force
or use the below code to deploy all solutions in one go:
#Deploy all installed solutions in the farm
Get-SPSolution | ForEach-Object { if (!$_.Deployed) {
 If ($_.ContainsWebApplicationResource -eq $False) {
    Install-SPSolution -Identity $_ -GACDeployment 
 }
else {
    Install-SPSolution -Identity $_ -AllWebApplications -GACDeployment 
  }
 }
}

Deploy SharePoint Solution Manually:
or You can deploy from SharePoint Central Administration site manually.
  • Navigate to SharePoint 2013/2016 Central Administration site.
  • Click on System Settings >> Manage Farm Solutions under Farm Management
  • Pick the relevant solution from the solution store
  • Click on "Deploy Solution" to start deploying the solution.
    sharepoint powershell deploy multiple solutions
You may also have to activate necessary features that came through deployed solutions!

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Change Log Files Location for Diagnostic (ULS/Trace) Log, Usage and Health Data Collection

No doubts, diagnostic logs and "Usage and health data" logs are extremely helpful. However, it could cause performance issues and slow down SharePoint if not managed properly. These logs can use large amounts of drive space and can affect server performance. Also can quickly fill the system disk which could potentially bringing the entire system down!

So,  it is recommended to change these log files to a different drive.

How to change Diagnostic Logging location in SharePoint 2013?
By default, logging is configured to write logs to the drive and partition where SharePoint 2013 is installed at "C:\Program Files\Common Files\Microsoft shared\Web Server Extensions\15\LOGS". Changing the SharePoint 2013 log settings can be done using PowerShell or Central Admin.
  • Go to Share 2013 Central Administration >> Monitoring 
  • Click "Configure diagnostic logging" Under Reporting groupchange sharepoint 2013 diagnostic log file location
  • Scroll down and set location for diagnostic log files. E.g. Set the log location to "D:\SPLogs\ULS"set log file location for ULS/Trace Logs in sharepoint
  • Click on "Ok" button to save your changes.
Additionally, you can set other related options such as the number of days to keep the log files, maximum disk space for log files.

Set Diagnostic log file location using PowerShell:    
Use the following command to change the diagnostic log file location.

Set-SPDiagnosticConfig -LogLocation "D:\SPLogs\ULS"  

You can combine it with other settings: 
Set-SPDiagnosticConfig -LogLocation "D:\SPLogs\ULS" -DaysToKeepLogs 90 -LogMaxDiskSpaceUsageEnabled -LogDiskSpaceUsageGB 50

Set Usage and Health Data Collection log location:
Click on "Configure usage and health data collection" link under "Reporting Group" of Monitoring section in SharePoint 2013 to change usage and health data collection log files location. E.g. Set the log location to D:\SPLogs\Health.
sharepoint 2013 usage and health logging

Set SharePoint 2013 usage and health log file location using PowerShell
Use this PowerShell command to change the Usage and usage and health data collection log files location:
Set-SPUsageService -UsageLogLocation "D:\SPLogs\UsageLogs"

Related Post: Configure Diagnostic Logging in SharePoint

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Saturday, April 4, 2015

Load SharePoint Snapin to Powershell ISE by Default

Problem:  If you use the PowerShell ISE to edit your SharePoint-PowerShell scripts, you may noticed that SharePoint cmdlets are not available by default until you explicitly load them with "Add-PSSnapin" cmdlet. This is because the ISE doesn't load SharePoint PowerShell Snap-ins by default.

Solution: Here is the nifty trick to load SharePoint snap-in in PowerShell ISE by default! All you have to do is: Add the SharePoint snap-in to your PowerShell ISE profile file, which is getting executed each time you fire PowerShell ISE! Here is how:
  1. To make sure that the profile file is created, run:
    #Check if the profile file exists already
    if (test-path $profile) 
    { 
        write-host "profile file already exists at: $profile" 
    } 
    else
    {
        #Create the profile file
        New-Item -type file -path $profile -force 
        write-host "profile file has been created!" 
    }
      
    This script will create a new profile file, if it isn't created already! Your output will be something like:
    add sharepoint snapin to powershell ise
  2. Open the profile file you received from above script, Add the below line to it. (in my case, its: C:\Users\salaudeen\Documents\WindowsPowerShell\Micro
    soft.PowerShellISE_profile.ps1)
    Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue
  3. Save and close
So, from now on, you don't need to explicitly load SharePoint PowerShell snapins as your first line of script! This will definitely save your time and enhance your scripting experience. To make this change for all users, use: $profile.AllUsersAllHosts instead of $profile in the above script.

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Thursday, April 2, 2015

Co-Authoring Feature in SharePoint 2013 - FAQs

What is co-authoring exactly means?
Co-Authoring is an amazing feature in SharePoint - Office Web Apps which allows multiple users to edit and collaborate concurrently in real time. Yes, You heard it right! Multiple authors can edit one document (Word, Excel, PowerPoint, etc) and simultaneously other user's changes will be reflecting to everyone! Its definitely a great productivity boosting feature.

Multiple users can work on a same document at the same time while they see each other works in the document, so they don't make any conflicts as they make edits. There is no limit in number of users. Any number of people can work on the same document at the same time.

How to use Co-Authoring in SharePoint 2013 with Office Web Apps:

Here is how the Co-authoring works in Excel documents with SharePoint 2013 - Office Web Apps:

Step 1: Navigate to any document library/folder where your Excel files are stored. Click on the context menu button and click on More options as in the below screen.
co authoring in sharepoint 2013

Step 2: Choose “Edit in Browser” menu item from the context menu.
 excel co authoring sharepoint 2013
Step 3: This launches your Excel Sheet in Edit mode in the browser. You can get the changes as soon as it’s made by any other user - concurrently editing the document.

When more than one person are working on the same file, You'll get all author's name at the bottom right section.

co-authoring office web apps sharepoint 2013
Alternatively, You can just click on the document to launch it in read-only mode in the browser and then click on "Edit in Browser" command from the ribbon.

Please note, Co-Authoring feature is not available through on all office clients (E.g. Co-authoring is available only through Excel Web Apps for Excel spreadsheets. For word documents, Co-Authoring is available via Microsoft Office Word Application). Also, It doesn't work when you enable check-in/check out functionality! Refer this technet link for supported clients: Overview of co-authoring in SharePoint 2013
Tips: Multiple People can work on a Excel file stored in UNC network share, via "Shared Workbook feature" of Excel. Just click on "Share Workbook" under Review tab.


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


You might also like:

Related Posts Plugin for WordPress, Blogger...