0

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

2 Answers 2

1

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.

0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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