Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Automatcally Clear all filter on opening Powerpivot

已答复 Automatcally Clear all filter on opening Powerpivot

  • Thursday, November 10, 2011 3:30 AM
     
     
    Sign In to Vote
    0

    HI,

    I need to automatilly clear all filters when opening a PowerPivot from PivotGallery. In Excel there is a functionbottom 'Clear filters', is there to acceive this?

    Larra
     

All Replies

  • Monday, November 14, 2011 8:51 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Larra,

    It will not clear all the filters automactially when you open a PowerPivot from PivotGallery if your original PowerPivot including the Filters, it will keep the same as your original one,  if you do not want to have the filters, you can clear them in advance, then deploy them to the sharepoint gallery. Thanks for your understanding.

    Regards,
    Challen Fu

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.