Sunday, May 24, 2009

How to Retain Filters when Export to SpreadSheet

          Let me explain the title of this article first. We pretty well know that sharepoint has integration with office and as a part it provides "Export to SpreadSheet" option for any sharepoint list. Issue here is after data in the list is exported to excel/spreadsheet the filters are ignored if any applied to the list.When i say filters to list these are applied just by clicking on the list column but not under "Modify View". After crawling on blog network found that these filters are getting ignored with latest version(2007) of office. Still i'm wondering if any custom solution can be done for this. Please comment on this and provide me a solution irrespective of the date of post.


No comments:

Post a Comment