sharepoint cannot export all fields to spreadsheet

Question

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

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
I expect when i find that out I know how fix the export problem as well.. — Colin Dekker, Aug 26 '09 at 10:37
Hmm, tried to edit the DispForm, added a DataFormWebPart, the datasource shows the PubStart and PubExp dates, won;t be rendered in XSL though, this is gettign weirder by the minute... — Colin Dekker, Aug 26 '09 at 11:54

score 1 · Answer 1 · answered Nov 06 '09 at 14:05

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.

answered Nov 06 '09 at 14:05

Philipp Schmid

359
2
6
18

score 0 · Answer 2 · answered Aug 26 '09 at 09:50

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.

answered Aug 26 '09 at 09:50

Veynom

206
3
10

sharepoint cannot export all fields to spreadsheet

2 Answers2