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

Posted by yitnoku

» access, » datasheet, » excel, » explorer, » grayed out, » Microsoft Office, » outlook, » powerpivot, » ribbon, » SharePoint, » SharePoint 2007, » Sharepoint 2010, » SharePoint 2013