« Risk Management is a game without end

Slicers and Filters in Excel 2010 Pivottables

I’m not sure if what I experienced is a bug or a feature….
I created a pivottable in Excel 2010 with slicers and made a selection via the slicers.
So far so good but when I wanted to see the records for a specific datapoint and double click on this point it will give me the complete recordset not taking into account the slicer settings.
But when I put in pivottablefilters for the same fields as the slicers it all works like good old pivottables doubleclicking.

Does anybody know if this is a feature or a bug….?

This entry was posted on Friday, May 28th, 2010 at 8:28 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Slicers and Filters in Excel 2010 Pivottables”

  1. sam Says:
    June 26th, 2010 at 11:27 am

    Looks like a Bug !

  2. JOHNNY Says:
    July 21st, 2010 at 4:06 pm


    Medicamentspot.com. Canadian Health&Care.Best quality drugs.No prescription online pharmacy.Special Internet Prices. Low price drugs. Order pills online…

    Buy:Zetia.Benicar.Seroquel.Nymphomax.Ventolin.Lasix.Lipothin.Amoxicillin.Cozaar.Wellbutrin SR.Acomplia.Aricept.Lipitor.Prozac.Female Pink Viagra.Zocor.SleepWell.Female Cialis.Advair.Buspar….

Leave a Reply