none
The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls,

    Question

  • The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of 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.


    Hey guys I have this showing up on my list that I can not see the Datasheet view. I have added sharepoint as a trusted site, enabled all my active x controls, I have update internet explorer 8, working on windows 7, and have installed office 7. I dont understand whats going on here. It works for the majority of our employees, but not all. Is there something I'm missing.

    I've googled the ____ out of this and have seen this issue being talked about around 2007 but nothing recently so im guessing there is an answer out there that I havent found. Please help
    Wednesday, July 28, 2010 6:13 PM

Answers

  • So I've been searching and adjusting and updating.... and I now have the datasheet view. This is how I got it.

    I am operating windows 7, IE8, and all Office 2007, NO 2003.

    I checked microsoft for all updates, I had to run this a couple times because it seemed that the first run of updates would trigger another run of updates and then another till there was no more.

    After this I switched from running Internet Explorer (64-bit) to Internet Explorer (32-bit). Presto.

    Pretty sure the datasheet view will not work on 64-bit.

    Wanted to post this because everyone elses problem seemed to be running a combo of Office 2003 and 2007 programs and my system was all current.

    Hope this helps someone!!!

    • Marked as answer by kbuzenius Wednesday, July 28, 2010 10:55 PM
    Wednesday, July 28, 2010 10:54 PM

All replies

  • So I've been searching and adjusting and updating.... and I now have the datasheet view. This is how I got it.

    I am operating windows 7, IE8, and all Office 2007, NO 2003.

    I checked microsoft for all updates, I had to run this a couple times because it seemed that the first run of updates would trigger another run of updates and then another till there was no more.

    After this I switched from running Internet Explorer (64-bit) to Internet Explorer (32-bit). Presto.

    Pretty sure the datasheet view will not work on 64-bit.

    Wanted to post this because everyone elses problem seemed to be running a combo of Office 2003 and 2007 programs and my system was all current.

    Hope this helps someone!!!

    • Marked as answer by kbuzenius Wednesday, July 28, 2010 10:55 PM
    Wednesday, July 28, 2010 10:54 PM
  • Thanks for your sharing.
    Everything will be fine.
    Thursday, October 21, 2010 2:40 AM
  • Well thanks kbuzenius, however I am running Win 7 32bit, MSIE 9 32 bit, and mostly Office 2007.  (I just noticed I have a copy of Outlook 2003 installed.  I've no idea why its there.)

    Because my OS is Win7 32 bit, I don't believe any of my apps (MSIE or otherwise) are 64 bit (but its possible I am wrong).  

    I'm going to dig a little deeper into this issue and report back.

    Monday, September 10, 2012 2:40 PM
  • ok.  Got it working.  I found this elsewhere:

    "I have been able to resolve most of these Office incompatibility issues by Just running MS Office Diagnostics.

    Takes several minutes to run but ususlly fixes the problem (browser crash while opening office doc, unable to edit in datasheet view, others).

    Start > All Programs > Microsoft Office > Microsoft Office Tools > Microsoft Office Diagnostics"

    I did the instructions above.  It did take several minutes (10-15) to run.  It told me something about "Repairing an installation problem".  

    The error message went away.  The Access Web Datasheet from a Sharepoint Site now seems to work fine.

    Monday, September 10, 2012 3:16 PM
  • I found that in the office most users are still running MS Office 2003 on Windows XP and Internet Explorer 7.   Many users were unable to use the datasheet view and activeX etc was unable to fix it.   By having the users install MS Access 2003 it resolved the dependencies and the datasheet views now work for them.
    Tuesday, September 11, 2012 10:33 PM