How can we improve Excel for Windows (Desktop Application)?

Make slicers visible "On Demand".

Allow the user to configure if the slicer is always in view or pops up on-demand. Activation/visibility could be triggered by selecting a visible report filter field or pivot table column header. Alternately, a report filter field could be configured to pop-up a slicer instead of, or in addition to the normal selection box. Another alternate would be to have report filter field style boxes independent of the pivot table range which would pop-up the slicer when selected. Lastly, a slicer selection panel could be added with a list of parameters to choose which would cause the slicer to pop-up

The core benefit of this function would be to reduce the amount of physical space occupied by static slicers on a crowded pivot table page. Slicers are superior to report filter boxes since the indicate which field parameters are not available due to other filtering actions on the same pivot.

A VBA-enabled file is provided as an example, which is also published at www.contextures.com

16 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Alex JankowskiAlex Jankowski shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Kim MullinsKim Mullins commented  ·   ·  Flag as inappropriate

        Alex has a valid idea. We who use Slicers on a regular bases would welcome this feature!
        Thank for keeping all the MS Product line number one in innovative tech. that makes our work less probematic, and delivery so professional looking!

      Feedback and Knowledge Base