This is a known and personally experienced issue (Tech Preview and Beta Builds as well) with Datasheet View not working in SharePoint if you have Office 2010×64 clients installed on your workstation.
Again this is one of the FAQ on the MSDN Forums and today I saw the solution posted on the thread, so comes this post for my reference and in case you experience this, then you know what is the solution to the issue.
Today I received a call from one of my clients requesting help with a SharePoint error.
The client had uploaded an Excel spreadsheet and when trying to update the properties of the document, SharePoint displayed this error “Unable to update the information in the Microsoft Office document”.
Outgoing email address is configured to email@example.com. This mailbox is not configured on local SMTP server (Exchange 2003). Hence SharePoint cannot send email via Exchange as open relay is turned off; as it should be.
Outgoing email address should be configured to firstname.lastname@example.org -an active local mailbox. Test that you can access local.user mailbox either through Outlook Web Access or Outlook client.
Event Type: Error Event Source: crypt32 Event Category: None Event ID: 8 Date: date Time: time User: user name Computer: computer name Description: Failed auto update retrieval of third-party root list sequence number from:
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt> with error: The specified server cannot perform the requested operation. For more information, see Help and Support Center at http://support.microsoft.com.