How to: Export a Discussion topic List item (SharePoint 2007) to excel or PDF ?

How to: Export a Discussion topic List item (SharePoint 2007) to excel or PDF ?

Here is  some tricky way to achieve this GOAL.

When you reply to a discussion it changes to Flat view and redirected to flat.aspx page.

So to export discussion topic in excel you have to manually change the URL from flat.aspx to allitems.aspx.

i.e. to enable export to spreadsheet option URL should behttp://siteURL/Lists/discussionname/allitems.aspx

Else to export from “Flat view” try following steps:

·         Open Excel.
·         Click on DATA tab.
·         Select from Web option.
·         Then in URL provide the URL with http://siteURL/Lists/discussionname/flat.aspx.
·         This will open a page with Allitems.aspx in pop up and then you can select (arrows) to insert required data to excel.
·         And from Excel you can easily export to PDF.

Feel free to reach me in case of any queries / issues.
Leave a Comment
  • Please add 8 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Maheshkumar S Tiwari edited Original. Comment: Added Tag and minor edit

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Maheshkumar S Tiwari edited Original. Comment: Added Tag and minor edit

Page 1 of 1 (1 items)