co authoring excel sharepoint 2010 / SharePoint 2013

TechNet article provides guidance for administrators to configure co-authoring for their organization. Many of these are using Windows PowerShell cmdlets.

• Configure versioning for co-authoring (SharePoint Server 2010) - When multiple authors work on the same document, edits are retained on the server as document versions. This article describes how to configure document library versioning settings for co-authoring.
• Configure the co-authoring versioning period (SharePoint Server 2010) - When versioning is turned on, SharePoint Server takes periodic snapshots of documents, saving them for later reference. This article describes how to configure the co-authoring versioning period.
• Configure the maximum number of co-authoring authors (SharePoint Server 2010) - Administrators can limit the maximum number of authors that can co-author a document at the same time. This article describes how to configure the maximum number of co-authoring authors
• Disable co-authoring (SharePoint Server 2010) - Co-authoring can also be disabled on the client side using Group Policy. This article describes how to disable co-authoring

Business Data Connectivity: SP2010 + SP2013

How to create business data connectivity service application

http://sharepointknowledgebase.blogspot.com/2014/03/how-to-create-business-data.html

Access Denied by Business Data Connectivity – Resolved

http://sharepointknowledgebase.blogspot.com/2014/04/access-denied-by-business-data.html

Business Data Connectivity metadata store is currently unavailable

http://sharepointknowledgebase.blogspot.com/2014/03/the-business-data-connectivity-metadata.html

Sandboxed Solutions - SharePoint 2010

The site collection containing this sandboxed solution has exceeded its daily resource usage quota

http://sharepointknowledgebase.blogspot.com/2014/03/the-site-collection-containing-this.html

Sandboxed code execution request failed - Resolved

http://sharepointknowledgebase.blogspot.com/2014/03/sandboxed-code-execution-request-failed.html

http://curah.microsoft.com/59506/sandboxed-code-execution-request-failed

Save site as template: SP2010 + SP2013 + SP2007

No save site as template in SharePoint 2013

http://sharepointknowledgebase.blogspot.com/2014/04/no-save-site-as-template-sharepoint-2013.html

http://curah.microsoft.com/64413/no-save-site-as-template-sharepoint-2013

Save site as template missing

http://sharepointknowledgebase.blogspot.com/2011/07/save-site-as-template-is-missing.html

Save site as template

http://sharepointknowledgebase.blogspot.com/2012/01/saving-site-as-template.html

Activating the site template in the solution gallery

http://sharepointknowledgebase.blogspot.com/2012/01/activating-site-template-in-solution.html

What is SharePoint site template

http://sharepointknowledgebase.blogspot.com/2012/01/what-is-sharepoint-site-template.html

PerformancePoint Services SharePoint 2010 + SharePoint 2013

http://sharepointknowledgebase.blogspot.com/2013/11/code-blocks-are-not-allowed-in-this.html

http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

http://sharepointknowledgebase.blogspot.com/2013/10/this-data-source-cannot-be-used-because.html

http://sharepointknowledgebase.blogspot.com/2014/04/were-sorry-we-ran-into-problem.html

http://sharepointknowledgebase.blogspot.com/2013/07/cannot-connect-to-performancepoint.html

http://sharepointknowledgebase.blogspot.com/2014/04/performance-point-service-could-not.html

Site Use Confirmation and Deletion

http://sharepointknowledgebase.blogspot.com/2014/02/site-use-confirmation-and-deletion.html

Last Access date / time for site collection

How to find out dead sites? 

How to find out unused sites? 

How to find out the sites which has not been updated from a long time? 

How to find out the sites which has not been updated from a long time? 

http://sharepointknowledgebase.blogspot.com/2014/02/last-access-date.html

Backup-Restore in SharePoint 2013 + Backup & Recovery Tools

Backup-Restore operations in SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/08/backup-restore-in-sharepoint-2013.html

access services problem in SharePoint 2010

Access services is unable to process the request
http://sharepointknowledgebase.blogspot.in/2013/08/access-services-is-unable-to-process.html

Cannot publish access database to SharePoint 2010 Server
http://sharepointknowledgebase.blogspot.in/2013/02/cannot-publish-access-database-to.html

If you are facing this error: 
There was an error in communicating with Access Database Service Access Database Service URL exception: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server

Then request you to refer the following KB: 
http://support.microsoft.com/default.aspx?scid=kb;en-us;2398833&sd=rss&spid=14944

If you are facing the following symptoms: 

1- Event ID: 24 Description: There was an error in communicating with Access Data Services exception: <exception description> [Session: <session ID> User: <username>].

2-  Event ID: 25. Description: There was an error in communicating with Access Data Services exception: <exception description> [Session: <session ID> User: <username>].

3- Event ID: 26. Description: Unable to reach Access Data Services. [Session: <session ID> User: <username>].

then request you to check the following article: 
http://technet.microsoft.com/en-us/library/ee513086(v=office.14).aspx

EXCEL + OFFICE + Ribbon grayed out features

Hello All, 
I have created this knowledgebase to share the break fixing solutions as well as what kind of troubleshooting I have executed towards that specific issue. Today’s KB is based on EXCEL + OFFICE that we use on regular basis by means of SharePoint site. 

Workbooks fail to load + Event 5231 + Event 5239 + Event 5240 + Error communicating with Excel Services Application + Unable to process the request = SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/workbooks-fail-to-load-event-5231-event.html

The specified file is not a valid spreadsheet or contains no data to import - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/the-specified-file-is-not-valid.html

An Excel workbook that contains a PowerPivot table is corrupted after you upload the Excel workbook to a SharePoint PowerPivot gallery
http://sharepointknowledgebase.blogspot.in/2013/09/an-excel-workbook-that-contains.html

The list cannot be displayed in DataSheet view – SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/the-list-cannot-be-displayed-in.html

Your client does not support opening this list with Windows Explorer + IE10 + Windows 7
http://sharepointknowledgebase.blogspot.in/2013/09/your-client-does-not-support-opening.html

SharePoint 2010- New Document requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater. To add a document to this document library click the Upload Document button
http://sharepointknowledgebase.blogspot.in/2013/08/sharepoint-2010-new-document-requires.html

Ribbon grayed out features (Extremely imp on day 2 day functionality)

Connect to office disabled in SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/connect-to-office-disabled-in.html

Sync to SharePoint workspace greyed out - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/sync-to-sharepoint-workspace-greyed-out.html

To export a list, you must have a Microsoft SharePoint Foundation-compatible application - SharePoint 2010 + SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/to-export-list-you-must-have-microsoft.html

Upload Multiple Documents is disabled in Document Library- SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/upload-multiple-documents-is-disabled.html

How to enable ‘New Folder’ option in document library + Custom list + New Folder disabled - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/how-to-enable-new-folder-option-in.html

Datasheet view is disabled SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/datasheet-view-disabled-sharepoint-2010.html

Authentication provider disabled SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/authentication-provider-disabled.html

"Connect to Outlook" Disabled - SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/connect-to-outlook-disabled-sharepoint.html

Open with Explorer is disabled - SharePoint 2010 and SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/open-with-explorer-is-disabled.html

Upload Multiple Documents is disabled - SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/upload-multiple-documents-is-disabled_1.html

backup-restore in SharePoint 2010

Hello All,

I know backup-restore is a very important entity in SharePoint 2010 and is being heavily used by Administrators/Developers/IT Pros.

Please refer the following articles based on the same, Thank you

SharePoint 2010: Backup/Restore with PowerShell Command 
http://sharepointknowledgebase.blogspot.in/2012/06/sharepoint-2010-backuprestore-with.html

Backup Restore in SharePoint 2010 
http://sharepointknowledgebase.blogspot.in/2012/06/backup-restore-in-sharepoint-2010.html

Delete List Using PowerShell

http://sharepointknowledgebase.blogspot.com/2013/05/deletion-of-subsite-site-collection.html