Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm having custom list (SharePoint 2007)

I need to export the list to Excel file. So I mark all the field that I want to export.

but I when I export the list I can see:

  1. the "Path" field, though that I did not mark this field as field that I want him to show in the defualt view.
  2. some field that I defined as hide field in the default view.

how can I avoid thos thing

share|improve this question

2 Answers 2

What you need to do to ensure that the fields you don't want to see are not exported, is create a view that shows only those fields that you want to see and export that view. As far as the "Path" that field is exported by default, and you will have to manually delete it from the excel spreadsheet.

share|improve this answer

Record and format an excel macro to format the list and remove the excess fields after export; see this answer for details: SharePoint 2007 List export to Excel 2007

share|improve this answer

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.