SharePoint 2010 Export to Excel 2010 Fails to Export All Fields in Some Views

Symptoms: Users report that on some views in a SharePoint 2010 document library or list, the export process results in an Excel table with the first column missing. Additionally, the first column in the table is Content Type, regardless of the view’s original column order. No error is reported by the application. Users of Excel 2007 are able to export the list without missing data and without errors.

Cause: Bug. Possibly because Excel 2010 is not able to sucessfully convert the object data in the Content Type field to text.

Resolution: Remove the Content Type field from the columns to be displayed in the view. (Switch to the view>Modify View> uncheck the box next to the field “Content Type”>OK).  Note that you will still be able to filter, but not sort, the results by Content Type, even if the Content Type field is not displayed.

Advertisements

About Joy Lavigne (Adkins)

SharePoint Administrator for a mid-sized organization. Frequent speaker at SharePoint Saturday events. Teller of terribly corny jokes. View all posts by Joy Lavigne (Adkins)

3 responses to “SharePoint 2010 Export to Excel 2010 Fails to Export All Fields in Some Views

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: