Cannot get the list schema column property from the SharePoint list

March 3rd, 2010 | Categories: SharePoint

If you’re trying to export data from a SharePoint list to Excel you might get this error message. Possible causes / solutions:

1. Change all Date and Time columns to single line of text and then back to Date and Time. Don’t worry, the data in these columns will be preserved.

2. There is a Microsoft Post-SP1 hotfix available here. It doesn’t fix lists that already have this issue though

3. If you export data to from SharePoint 3.0 / 2007 to Excel 2003 you might be getting this kind of error

4. If you’re exporting multiple choices field to Excel 2003

5. If you rename a Date and Time column this error may occur. Create an additional column and copy-paste values in a DataSheet view from one column to the new one

6. Changing the default date for Date and Time column from "Today" to "None" and then back may resolve the issue

All of the above solutions still didn’t work for me. What did the trick was following:

7. Lookup column points to a calculated field. Changed the lookup column to not point to calculated field but to a Single Line of Text field and the problem went away.

Technorati Tags: ,