Default Cell location AFTER slicer selection.

[RobertCotton]

I have a sales dashboard report based on several pivot tables. I use a "master" slicer that is connected to all of the pivot tables so that when a vendor is selected all of the reports and charts update accordingly. My issue is that each time I select an individual vendor from the slicer the selected cell in the spreadsheet defualts to a specific cell (in this case B74). This causes the user to have to navigate back to the top of the sheet to review the dashboard.

My question is "Is there any way to change this so that it will default to A1 instead of B74 after the slicer selection is made?"

Thanks for any help anyone can give me.

Robert Cotton

 

[COrmerod]

Not sure if you are still looking for this but just solved a similar problem.

The cell it is defaulting to is the top left corner of the primary pivot table connected to your master slicer.

My solution was to add a tiny pivot table in the top left hand corner (A1) and make this the primary pivot table for the slicer(s). You can do this by de-connecting all of the other pivot tables in 'Filter Connections' except the new one, pressing ok, and then adding them again. Now the curser should default to A1 whenever something is selected, (you can hide the left-most columns so that it is not visible), and if you freeze panes the top of the tab with the slicers showing, you screen should not visibly move when a slicer change is made.

Hope this is helpful to someone!