locked
Export to excel breaking wiht lookup field RRS feed

  • Question

  • I have been doing some research on the issue of users trying to export lists to excel with lookup fields and the import breaking in excel.

    We get a "Cannot get the list schema column property from the SharePoint List"

    I know that there is the work around/solution of excluding that column form the view when you export but our users are requesting that they need to be able to export these columns as well.

    Has there been a permanent solution proposed for this issue?

     

    My apologies if i have over looked a solution that has already been posted but i could not find it.

     

    Thank you for any feedback!

    Thursday, February 24, 2011 8:34 PM

Answers

  • Yes.

    Create a sample list.

    Open it in datasheet view.

    Make sure all the Fields are there in the same order that is in your excel sheet.

    Note: Do not paste in created, createdby, modified, modified by, ID fields. because they are read only fields.

    Select all the content in excel sheet and paste it in the list.

     

    NOTE:- First test on a test list dont play with main list.


    ANJI Y
    • Marked as answer by Leoyi Sun Thursday, March 3, 2011 2:10 AM
    Friday, February 25, 2011 3:34 PM
  • I think thats one of the reasons.

    There could be lots of reasons for that.

     

    In the work around that i told you: What it will do is.

    When you copy and paste the text in the lookup fields, sharepoint will take the text and automatically identifiy the lookup value that you are trying to paste.

     


    ANJI Y
    • Marked as answer by Leoyi Sun Thursday, March 3, 2011 2:10 AM
    Friday, February 25, 2011 4:48 PM

All replies

  • Did you try to just copy and paste the content into list?
    ANJI Y
    Thursday, February 24, 2011 11:31 PM
  • no we have not. So you would like me to try and copy and paste the list contents into excel?
    Friday, February 25, 2011 3:07 PM
  • Yes.

    Create a sample list.

    Open it in datasheet view.

    Make sure all the Fields are there in the same order that is in your excel sheet.

    Note: Do not paste in created, createdby, modified, modified by, ID fields. because they are read only fields.

    Select all the content in excel sheet and paste it in the list.

     

    NOTE:- First test on a test list dont play with main list.


    ANJI Y
    • Marked as answer by Leoyi Sun Thursday, March 3, 2011 2:10 AM
    Friday, February 25, 2011 3:34 PM
  • Copy and pasting works.

     

    I am starting to wonder if this issue is caused by the fact that the lookup field is pulling items from two different lists and if in one of those lists i do not have access to one of the lists and that is what is causing this error to occur.

    Friday, February 25, 2011 4:41 PM
  • I think thats one of the reasons.

    There could be lots of reasons for that.

     

    In the work around that i told you: What it will do is.

    When you copy and paste the text in the lookup fields, sharepoint will take the text and automatically identifiy the lookup value that you are trying to paste.

     


    ANJI Y
    • Marked as answer by Leoyi Sun Thursday, March 3, 2011 2:10 AM
    Friday, February 25, 2011 4:48 PM