When someone tries to open an Office file in their local client instead of using Office Web Apps or directly tries to edit a document in Office, the above error might show up or this one;
Solution
By default, the Datasheet view of a list or library is not supported when you are using the 64-bit version of Microsoft Office 2010 installed on a 64-bit Windows operating system.
If you want to use Datasheet view, we recommend that you install the 32-bit version of Microsoft Office on a 64-bit Windows operating system.
If your business needs require using the 64-bit version of Office 2010, you can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available here on the Microsoft download center:
2007 Office System Driver: Data Connectivity Components
Find out if your Office is 32- or 64-bit
To find the bit version of Microsoft Office 2010, on the File tab, Click Help, and then note the bit version under the About section.
Find more information about 64-bit Office 2010 in the See Also section.
The 2007 Office System Driver: Data Connectivity Components install a 32-bit version of the Datasheet component that will work with the 64-bit version of Office 2010 as long as you are using a 32-bit version of an Internet browser.
IMPORTANT If you are using a 64-bit version of an Internet browser, for example the 64-bit version of Microsoft Internet Explorer 8.0, there is no support for the Edit in Datasheet feature.
You must install all 64-bit versions of Office products before you install the 2007 Office System Driver: Data Connectivity Components.
For example, if you plan to install Microsoft Project 2010, Microsoft Visio 2010, or Microsoft SharePoint Designer 2010, components that are not installed as part of an Office 2010 suite, you must install the 64-bit versions of these products before you install the Data Connectivity Components.
There might be other reasons why Datasheet view is not working, including the following:
Next
Install
OK
If you select a List in SharePoint 2010 now and select 
It WILL open in Datasheet View
To synchronize a SharePoint list, you must have a compatible spreadsheet program, such as Excel 2010, installed on your client computer, and you must have read permission to the list.
NOTE The following instructions use Excel 2010 as an example. If you are using a different spreadsheet program, consult the Help information for that program.
NOTE A SharePoint site can be significantly modified in appearance and navigation. If you cannot locate an option, such as a command, button, or link, contact your administrator.
Excel creates an Excel Table with a data connection based on a Web query file.
To see further changes made to the SharePoint list in spreadsheet program, you must manually update the data. For example in Excel 2010, in the Excel table connected to a SharePoint list, on the Design tab, in the External Table Data group, click Refresh.
You can synchronize data between a SharePoint list and a compatible spreadsheet program, and keep both sets of data up-to-date. For example you may want to maintain a product inventory in a SharePoint list so it’s easy to share and update, but also do periodic inventory analysis by using a spreadsheet program, such as Excel 2010.
There are three ways to synchronize data between a SharePoint list and a spreadsheet program. Whichever way you choose, this synchronization is one-way, or unidirectional. Changes made in the SharePoint list can be updated in the spreadsheet program, but any changes that you make in the spreadsheet program are not written to the SharePoint list.
To synchronize a SharePoint list, you must have a compatible spreadsheet program, such as Excel 2010, installed on your client computer, and you must have read permission to the list.
NOTE You cannot synchronize a SharePoint external list with a spreadsheet program.
You can synchronize the data in a SharePoint list with a compatible spreadsheet program by using the Export to Spreadsheet command in the list ribbon. As the SharePoint list continues to be updated, depending on your spreadsheet program, you can also use a command in your spreadsheet program to manually update your spreadsheet with the latest data.
For example in Excel 2010, you can refresh the data connection, which replaces and overwrites the Excel data with the current list data. If your SharePoint list contains folders, the folder structure does not appear in the resulting Excel table. However, the Item Type and Path columns are added to the Excel table so you can filter and sort the data, based on its type and location or subfolder of the list.
If you have Excel 2010 installed on your client computer, you can also synchronize a SharePoint list from Datasheet view by using the Query List with Excel command available in the Datasheet view task pane. Using additional commands in the task pane, you can also synchronize the list data and do the following:
From Excel 2010, you can also export an existing Excel table to a new SharePoint List by using the Export Table to SharePoint List Wizard. This approach is useful when you already have the data in an Excel table and you want to create a SharePoint list during the synchronization process.
When you create a new document for any given document library, the default type of document template available to you is a Microsoft Word document. But what if you want to quickly add a Microsoft Excel worksheet, a Microsoft OneNote document, or a Microsoft PowerPoint presentation to your Document Library? And what if you want each document type to follow a particular template so that all documents of a certain type are consistent?
This article is divided into the two steps necessary for creating and then adding content types to be used as templates for various file types within a Document Library.
NOTE : If your organization is using SharePoint Online/Microsoft Office 365, and you use the Microsoft Office Web Applications instead of Microsoft Office client programs, you must follow the steps in this article to enable users to create multiple Microsoft Office document types in a document library from within the browser.
NOTE You must be a site collection owner to successfully complete this procedure.
NOTE Note that, by default, the New Word content type exists under the Group Work Content Types section. This is typically the choice that is available to you when adding a new document to any Document Library.
NOTE You must have Microsoft Office installed in order to create Office generated documents.
NOTE You can also add a new Excel, OneNote or Word template by repeating the above steps for each file type.
NOTE You can create multiple and different templates of the same file type.
Now that you have created content types for your PowerPoint, OneNote, and Excel templates, you need to add the content types to a Document Library. This step ensures that they will appear as choices from the New Document command on the ribbon.
NOTE You can multi-select content types by pressing the <CTRL> key while clicking on several content types in the list.
Now that you have created content types for your PowerPoint, OneNote, and Excel templates and added them to the Document Library, you can save this library as a template. In this way, you won’t have to repeat the steps above if you want something similar for another Document Library.
NOTE You must have Designer permissions to accomplish this task.
