Hi Garry,

Agreed. I really appreciate you taking a look and trying. In the
meantime today, I had a thought for a sort of work around. It's not
perfect, but it's close. I'm still using the double-click event on
the Output sheet, which is putting the selected catalog number into a
variable, switching to the slicer sheet, putting that variable into a
specified cell, and the copying that cell to the clipboard. Then the
user doesn't have to remember or fatfinger in the number, but rather
just select the pivot table drop down and paste into the search field.
It works.

Again, THANK YOU for all your time and attention to my issue!

Frank

On Tue, 10 Apr 2018 14:05:43 -0400, GS wrote:

Ok Phrank, this puts me back to where/why I don't use Table objects; -doing
anything with them is pathetically slow! Sorry I can't help further...