locked
Document Library Datasheet VIew RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have a document library created in SharePoint. In InfoPath, I have created a form which is published to this library. I am able to fill the form but I am unable to edit it in Datasheet mode. When I try, I get the error "The selected cells are read-only". In Library Settings, Advanced Settings, I set YES for "Allow items in this form library to be edited using the datasheet?".

    Are the document libraries meant not to be edited with Datasheet mode?

    How can I solve this?

    Thank you.

    Wednesday, April 13, 2011 2:26 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    When you published the form from InfoPath to the Library, did you select what columns would be displayed in the library?  When you do that there is an option to say if those fields can be edited in datasheet view.  I would doublecheck that setting.
    ~Jennifer Mason ~My Blog~ ~SharePoint Support~ ~SharePoint Training~ ~Follow me on Twitter!~
    Wednesday, April 13, 2011 2:32 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

     

    When you deployed the form in Document Library, did you promote the fields?

    After that, you can edit the form in datasheet mode, but only those fields promoted on publishing.

     

    Paulo Livreiro

    Wednesday, April 13, 2011 2:36 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    When I publish, I promoted the fields. I see all my columns under "The fields listed below will be available as columns in SharePoint sites and Outlook folders".
    I don't see anywhere where I can see a setting related to this like Jennifer said.

    Do I need to add the fields to the section below?

    "The fields listed below will be available as SharePoint Web Part connection parameters"

    Thank you

    Wednesday, April 13, 2011 2:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You should see a checkbox when you configure what fields in your form match what columns in your library.
    ~Jennifer Mason ~My Blog~ ~SharePoint Support~ ~SharePoint Training~ ~Follow me on Twitter!~
    Wednesday, April 13, 2011 3:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Where do I see this option? I use InfoPath 2010. I checked "File"-> "Form Options" -> "Property Promotion". I see my fields in the top field. I don't see the setting you are referring to.

    Thank you.

    Wednesday, April 13, 2011 3:10 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Please see the link with the screenshot for the option I am referring to: http://www.sharepoint911.com/blogs/jennifer/PublishingImages/screenshot.png
    ~Jennifer Mason ~My Blog~ ~SharePoint Support~ ~SharePoint Training~ ~Follow me on Twitter!~
    • Marked as answer by Cisco 7970 Wednesday, April 13, 2011 3:38 PM
    Wednesday, April 13, 2011 3:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Publish again and on "Publishing Wizard - Promote Fields", check the box "Allow users to edit data in this field by using a datasheet or properties page".
    • Marked as answer by Cisco 7970 Wednesday, April 13, 2011 3:38 PM
    Wednesday, April 13, 2011 3:23 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You need to publish again (not Quick Publish).

    Go to >> File >> Publish >> Sharepoint Server (again not Quick Publish)

    Then, Publishing Wizard pops up.
    Wednesday, April 13, 2011 3:34 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Thank you very much, I needed to click "Modify" when a field is highlighted to see this checkbox.
    Wednesday, April 13, 2011 3:42 PM