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