EXCEL + OFFICE + Ribbon grayed out features

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

InfoPath Error: This session has exceeded the amount of allowable resources

Hello, 

I have published an infopath form on my SharePoint 2010 site collection and getting the following error message while opening: 
InfoPath Error: This session has exceeded the amount of allowable resources 

Resolution is very simple.

Here are the details:
Increase the form actions in configuring InfoPath services section as mentioned below:- 

Go to Central Administration of the SharePoint server. 

Click on Application Management 

In the section "InfoPath Forms Services"-->select Configure InfoPath Forms Services. 

In the Number of Actions per Post back, enter some max value around 250 or 300 depends on your project form requirement.

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? 

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