I just saw the following from our Product Quality team, and thought I would pass along the resolution. While 64-bit installations of Office 2010 are still relatively uncommon, there are a few known issues/growing pains, and this is one of them
Datasheet feature on SharePoint not available for customers who install the 64-bit version of Office 2010. When clicking on the Datasheet View, the following message is displayed:
The list cannot be displayed in Datasheet view for one or more of the following reasons:
Customers using the 64-bit version of Office 2010 are unable to use the Datasheet view of SharePoint lists. This issue occurs regardless of what version of SharePoint the customer is using: Windows SharePoint Services 2.0, Windows SharePoint Services 3.0, SharePoint Foundation 2010, SharePoint Server 2003, SharePoint Server 2007 or SharePoint Server 2010. The picture below is an example of the experience with SharePoint Server 2010 when you click the Datasheet View button.
The component that provides this functionality is not installed during the setup of the 64-bit version of Office 2010 because a 64-bit version of the Datasheet component does not exist.
Customers using the 64-bit version of Office 2010 can install the 2007 Office System Drivers: Data Connectivity Components to regain the Datasheet functionality when using the 32-bit version of an internet browser.
The resolution is documented in KB 2266203: You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010.
So we would need to change the OS back to XP64 bit - RAM limitations to get IE 7. Window 7 64bit is IE 8.
Or will that not work at all? We have to stay with 32 bit 4Gb ram?
This is total crap!! (Not your blog, this solution!)
You NEED a 64bit machine to run SharePoint designer 2010 which REQUIRES Office 2010 64bit. If you install the fix above it breaks SP Designer! What a load of rubbish. Come on Microsoft, get the finger out.
You can still run 32bit office on 64bit Windows. No need to run 64bit Office unless you have massive spreadsheets with powerpivot cubes.