none
Slicers won't stay where I move them - they "snap" back to original position?

    Question

  • Hi all,

    I've inserted some slicers into my excel sheet. When I try to move or resize them, they just immediately snap back to their original position.

    How can I prevent this, so that I can move them wherever I want on the sheet?

    Thanks much,

    sff

    Tuesday, August 13, 2013 2:49 PM

Answers

  • What version of Excel are you using 2010 or 2013? Are you using slicer in table or pivot table? There is no reason for slicer to move on its own. If you run a pivot report that might add the columns and rows that would relatively change the position. So keep the pivot starting point separate from the pivot area to avoid moving the slicer.
    Tuesday, August 13, 2013 9:01 PM