Export SharePoint list to excel doesn't show Version, works in Excel 2003 but not 2007

Question

I'm exporting a list from SharePoint with a particular view (that shows the Version of the item). Exporting to Excel 2003 the list contains the Version column however in Excel 2007 the Version column is missing. Any hints?

Answer 1

I do not know how to make the Version column show up in Excel 2007, but as a workaround you could:

• Create a new column (that you can call Version-export, or whatever you want to call it)
• Create a workflow with SharePoint Designer
• Make it start automatically when items are created and changed
• Use the "Set field in current item" action to retrieve the version and copy it to Version-export
• Version-export will then appear in your spreadsheet export

It might require some more tweakings, but here's the gist of it.