1

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

Improve this question
10
  • So no error, they just don't appear?
    – Alex Angas
    Aug 26, 2009 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, 2009 at 10:17
  • Is there a way to change which fields are shown in DispForm?
    – Colin Dekker
    Aug 26, 2009 at 10:20
  • Maybe through SP Designer but is it DispForm or some attribute on the fields?
    – Alex Angas
    Aug 26, 2009 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, 2009 at 10:35

2 Answers 2

Reset to default
1

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.

Improve this answer
0

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .