Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|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

2 Answers

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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