N/APosted on - 09/02/2011
Are you there and can you suggest a solution? I can't export data from a SharePoint list to a Microsoft Excel 2007 Spreadsheet. During the manipulation, I received this message
Cannot get the list schema column property from the SharePoint list.
What can I do immediately to resolve the issue?
Thanks for your time.
Excel: export data from Sharepoint list to Excel
Data can be easily exported from SharePoint to Excel as both are proprietary of Microsoft and strongly support each other. From the link bar you should select “Documents and Lists” and then select the option “export to excel”.
The Error you have posted is specific when you are trying to export data from SharePoint 3 to Excel 2003 and have some field/column which consists data containing date or time. First try to change its data type to simple text or if you have some lookup field to some formula field. After that, try to export data to Excel.
Hope it will help solve your problem.