I have spent the last hour looking at different forums looking for a solution to my issue.
I have a... "Product Family Slicer" with 5 products to choose from in the slicer.
However, each time you select a specific Product Family, the cursor jumps halfway across the spreadsheet and lands on it's connecting pivot table. This is annoying the heck out of me. I've run the gamut on looking at ways to "lock" my position on the spreadsheet to no avail.
I have no doubt this is a simple change, but I cannot find the "lock cursor position when making selection on slicer" checkbox.
Does anyone have a solution for this? Please and thank you all!
I have a... "Product Family Slicer" with 5 products to choose from in the slicer.
However, each time you select a specific Product Family, the cursor jumps halfway across the spreadsheet and lands on it's connecting pivot table. This is annoying the heck out of me. I've run the gamut on looking at ways to "lock" my position on the spreadsheet to no avail.
I have no doubt this is a simple change, but I cannot find the "lock cursor position when making selection on slicer" checkbox.
Does anyone have a solution for this? Please and thank you all!
