Datasheet View Error Sharepoint 2007

26, 20104 0 0 0 I just saw the following from our Product Quality team, and thought I would pass along the resolution. While 64-bit

Sharepoint 2007 Datasheet View Missing

installations of Office 2010 are still relatively uncommon, there are sharepoint 2007 datasheet view not working a few known issues/growing pains, and this is one of them Issue: Datasheet feature on SharePoint

Sharepoint 2007 Datasheet View Read Only

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 edit in datasheet view missing sharepoint 2007 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. Description: Customers using the 64-bit version of Office 2010 are unable sharepoint 2013 datasheet view 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. Resolution: 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. Tags Office SharePoint SharePoint 2010 Comments (4) Cancel

for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us

Sharepoint Datasheet View Cannot Be Displayed

SharePoint Questions Tags Users Badges Unanswered Ask Question _ SharePoint Stack Exchange is a question and sharepoint datasheet view default answer site for SharePoint enthusiasts. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can

Sharepoint Datasheet View Make Column Read Only

answer The best answers are voted up and rise to the top The list cannot be displayed in DataSheet view up vote 1 down vote favorite I have two SharePoint Enterprise 2010 sites in two different farms. Both sites I am https://blogs.technet.microsoft.com/seanearp/2010/07/26/resolution-to-missing-datasheet-view-with-64-bit-versions-of-office/ 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 http://sharepoint.stackexchange.com/questions/114756/the-list-cannot-be-displayed-in-datasheet-view 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. 2010 datasheet share|improve this question asked Sep 11 '14 at 7:17 Zakir HC 2,24921742 Have you set up excel services in both farms? Check that excel calculation service is started and that the excel service application is created. –Christoffer Sep 11 '14 at 7:31 This thread might help you to: social.technet.microsoft.com/Forums/sharepoint/en-US/… –Christoffer Sep 11 '14 at 7:32 Check that both sites are connecting using the same security level in IE. To do this open the working list, go to Internet options in IE and select the Security tab. I suspect this site will be Local Intranet or Trusted sites. Do the same for the site that doesn't work, I suspect you'll find its Internet. If it is try adding the site to the same security level as the one that works (Though you may find the option to do so is locked down as some companies have policies to prevent users changing these settings). –PistonBlown Sep 11 '14 at 12:15 PS Datasheet has nothing to do with Excel Services. Its controlled by a DLL that's supplied with Microsoft Office. If your running 64-bit Office then no

Fields Project Fields Resource Fields Sample Queries Admin Tools Re-associate Site Project Archival VBA MS Project Server Errors -> Datasheet view Error You receive The list cannot be displayed in Datasheet view for one or more of http://www.epmcentral.com/pjadmin/wssdatasheeterror.php the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled error message when you trying to view SharePoint https://support.office.com/en-us/article/Use-Datasheet-view-in-64-bit-Office-2010-f734e938-8baa-492e-84f4-85a7cc85645a list in Datasheet view. Possible Cause of Error: A Microsoft Office 2003 Professional edition is not installed on the computer ActiveX control settings may not be set properly in Internet Explorer If you are using MS Office datasheet view 2007, the Microsoft Office Access Web Datasheet Component and the Windows SharePoint Services Support components are not installed on your machine Please also read the article on microsoft which describes the causes for this error. You can use one or more of the following solutions to fix this error. Solution 1: Repair Excel 2003 Launch MS Excel 2003 Help menu -> Detect and Repair Once it repaired, close excel 2003 Try again to sharepoint 2007 datasheet access the list in Datasheet view Solution 2: Repair MS Project Professional 2007 Launch MS Project Professional 2007 (Server connection is not required) Help menu -> Microsoft Office Diagnostics Follow the prompts to complete the Diagnostics Exit MS Project Professional 2007 Application Try again to access the list in Datasheet view Solution 3: Verify ActiveX Control Settings Steps: Launch IE browser On Tools menu -> Internet options -> click on Security tab If you SharePoint site has been already added to trusted sites zone in IE, use Trusted Sites tab OR If your SharePoint site not added as trusted site in IE, use Internet tab Note: The following screen shot assumes, you addred SharePoint site as trusted site. Click on "Custom Level" under security level for this zone Look for ActiveX controls and plug-ins; under this option please set the following settings: Download signed ActiveX controls -> Prompt Run ActiveX controls and plug-ins -> Enable Script ActiveX controls marked safe for scripting -> Enable Click OK to close the IE settings window Click OK to close the IE options window The above settings will help in resolve the issue. You may need to close all opened browser windows and re-open the program before your new settings take hold and become active. Solution 4: Install Microsoft

view in 64-bit Office 2010 Applies To: SharePoint Server 2010, SharePoint Foundation 2010, Less Applies To: SharePoint Server 2010 , SharePoint Foundation 2010 , More... Which version do I have? More... 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 In this article Find out if your Office is 32- or 64-bit About installing the 2007 Office System Driver: Data Connectivity Components Other reasons Datasheet view might not work 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. About installing the 2007 Office System Driver: Data Connectivity Components 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. For more information about installing the 2007 Office System Driver: Data Connectivity Components, see the related Knowledge Base ar