MOSS 2007: List column error while importing to Excel



When we try to export list to MS Excel using option “Export to SpreadSheet”, following error message displayed:


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











Quick resolution is that if you are using MS Excel 2003; try it using MS Excel 2007. This should solve the problem.


Other way is that this is due to a column which has type “Date” or “Date and Time”. Remove such columns from a list view and try to import, you will soon find the trouble making column.


Create a column, copy the data from trouble making column and delete the trouble making column. You are good to go.


Sometimes changes column type from “Date” or “Date and Time” to “Single line text” and change it back to original type will solve the problem but this may result in loss of existing data.


We have a hotfix available as well:

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: