I have an Excel pivot table linked to an Access database table via MS
Query. The problem is the pivot pulls in all the table records, which
is about 1M records. I know I can filter the data using the pivot data
"wizard" or MS Query...but, is there a better way?

Maybe there's a way to use worksheet cell values as parameters for SQL
to use as the pivot data source, but I'm not sure how to go about
that.

Any suggestions on how to do this or a better way to filter the pivot
using Excel?

TIA....