Excel: export data from Sharepoint list to Excel

Asked By josh4 0 points N/A Posted on - 09/02/2011

Hi!!!!

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

 Error:

Cannot get the list schema column property from the SharePoint list.

What can I do immediately to resolve the issue?

Thanks for your time.

• Status: Open
• Question Views: 2486
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Abbie1 0 points N/A #121210

Excel: export data from Sharepoint list to Excel

Hey Josh,

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.

About Abbie1

Questions
0

Answers
10

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 09/07/2011
• Question Category: MS Excel