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).
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.