Export from MOSS 2007 to Excel 2010 - Missing Columns
Posted on 2011-04-19
I am exporting a SharePoint list to Excel 2010. When I export the list a number of columns are missing in the resulting Excel file.
Category (linked to item with with edit menu)
Type (icon linked to document)
Category (linked to item)
Edit (link to edit item)
The SharePoint list has 117 columns and all are exported but the ones listed above. I believe that these are all standard system generated SharePoint columns (except Category which a renamed Topic column) but I cannot find any documentation that indicates that these columns should not be exported.
So the question is - is there a reason why these columns are not being exported and is there a way to have them export (without writing code).