locked
"You cannot view a list in Datasheet view on a Web site in Microsoft Windows SharePoint Services 2.0 or in Microsoft Windows SharePoint Services 3.0." RRS feed

  • Question

  • Good Day,

     

    Can anyone tell any other reasons why this would occur?

    This started happening when the license of the users MS Office was changed from MS Professional to SBE, Is there any correlation to this?

    We only have WSS 3.0 not MOSS.

     

    Thank You!

    • Edited by Mike Walsh FIN Saturday, February 19, 2011 4:08 PM Quotes put around nessage text
    Saturday, February 19, 2011 10:14 AM

Answers

  • A different IE version is unlikely to help unless you are at the moment using something very old (or too new - it is not a good idea to use IE9 until it's at RTM).

    It will definitely not work if you don't have any version of Office installed.

    As for "do we need Pro", I can't answer it definitively. I suspect that may well be the case but the only SP version I am sure that needs Pro for this is WSS 2.0 (SPS 2003), for WSS 3.0 (MOSS 2007) I simply don't remember.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Monday, February 28, 2011 2:51 AM
    Monday, February 21, 2011 9:13 AM
  • Hi Omni,

    Support for WSS list data is available only in MS Office 2003 Professional editions.
    For more details, please read this kb. http://support.microsoft.com/kb/909506

    Thanks & Regards,
    Emir

    • Marked as answer by Leoyi Sun Monday, February 28, 2011 2:51 AM
    Tuesday, February 22, 2011 2:07 AM

All replies

  • It's probably connected.

    There are strict rules as to which Office products are recognized by the SharePoint system (it doesn't make any difference by the way if you have WSS 3.0 or MOSS 2007 as your SharePoint system) and in this case DataSheet View (which in v2 was looking for Excel) is I think looking for Access and if SBE doesn't include that, you would be out of luck.

    If I'm wrong and it is still looking for Excel (and you are using a production version of IE which is the other requirement) then it might be that the Excel version in SBE isn't suitable. There is a precedent for that - in v2 you needed Office Pro not Office Home for certain SP functions (including I think DataSheet View) to work.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Saturday, February 19, 2011 4:14 PM
  • Hi,

     

    Umm.. the reason why were a little doubtful of this is because we tried lunching a data list view on a PC WITHOUT MS Office..

    Is there any any recommended setting for this (like a different IE version) or do we really need to upgrade to PRO license?

    since were a little hesitant to upgrade the license of every user (since there's a lot).

     

    Thank You.

    Sunday, February 20, 2011 10:49 AM
  • A different IE version is unlikely to help unless you are at the moment using something very old (or too new - it is not a good idea to use IE9 until it's at RTM).

    It will definitely not work if you don't have any version of Office installed.

    As for "do we need Pro", I can't answer it definitively. I suspect that may well be the case but the only SP version I am sure that needs Pro for this is WSS 2.0 (SPS 2003), for WSS 3.0 (MOSS 2007) I simply don't remember.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Monday, February 28, 2011 2:51 AM
    Monday, February 21, 2011 9:13 AM
  • Hi Omni,

    Support for WSS list data is available only in MS Office 2003 Professional editions.
    For more details, please read this kb. http://support.microsoft.com/kb/909506

    Thanks & Regards,
    Emir

    • Marked as answer by Leoyi Sun Monday, February 28, 2011 2:51 AM
    Tuesday, February 22, 2011 2:07 AM