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

Posted: April 20, 2011 in Uncategorized

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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s