up vote 1 down vote favorite
share [g+] share [fb]

I am trying to make an export of a list in SharePoint to an Excel spreadsheet. I have added all needed fields to my default view of the list, (like Publishing Start Date / End date) but some fields (like Publishing Start Date / End date) don't show up in Excel. Any idea?

EDIT:

My setup is a MOSS standard edition, the needed fields (Publishing Start Date / End date) are standard SharePoint publishing fields.

The versions of Excel I tried it with are 2003 and 2007

link|improve this question
So no error, they just don't appear? – Alex Angas Aug 26 '09 at 10:15
Exactly, it looks like the fields that get exported are the same that are shown in the DispForm... – Colin Dekker Aug 26 '09 at 10:17
Is there a way to change which fields are shown in DispForm? – Colin Dekker Aug 26 '09 at 10:20
Maybe through SP Designer but is it DispForm or some attribute on the fields? – Alex Angas Aug 26 '09 at 10:30
The DispForm uses the ListFormWebPart to display fields with rendermode = display. The in turn Calls the DocumentLibraryForm ControlTemplate from the DefaltTemplates.ascx file. I looked into that file, but it seems it uses the DocumentLibraryFields control to actually render the fields... Not sure where that control gets it's list of controls to render from... – Colin Dekker Aug 26 '09 at 10:35
show 5 more comments
feedback

2 Answers

up vote 0 down vote

I suspect a date format error but you should provide more information. Does it concern MOSS or WSS, which version, and which version of Excel.

link|improve this answer
feedback
up vote 0 down vote

You can create a personalized view for which you can choose to display any field you have permissions for. This should allow you to select the missing columns, view, and export them.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.