I have two SharePoint Enterprise 2010 sites in two different farms. Both sites I am accessing with my local browser IE 10 (32-bit). List1 in Site1 can be opened in DataSheet view but List2 in Site2 cannot be opened in DataSheet view. I have 64-bit Office 2013 installed. I am using 64-bit Office but still can open List1 of Site1 in DataSheet view but cannot open List2 in Site2 in DataSheet view which is in another farm. This is quite strange! Any advice and suggestions what is wrong or missing?
Here is the common exception I encounter while opening List2 of Site2 in DataSheet view:
The list cannot be displayed in DataSheet view for one or more of the following reasons:
A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
Your web browser does not support ActiveX controls.
A component is not properly configured for 32-bit or 64-bit support.